The Monthly Publication of NAUG: The National AppleWorks Users Group
VolumeVI,No.11 Five Dollars
TABLE OF CONTENTS
Letters to NAUG 2
• How to save your UltraMacros
settings.
• Problems with RamFAST cards.
• How to transfer numeric data between
modules.
• Member wants Electronic Index Disk
update.
Novice Notes 4
• Our ten favorite AppleWorks tips.
Software Review 10
• Magic File Cabinet expands the
AppleWorks data base.
• A better technique for using Magic
File Cabinet.
My Favorite Macro 12
• Macros that modify AppleWorks.
Corrections 15
• Corrections to the AppleWorks
Forum.
Software Review 16
• SuperPatch offers exceptional Desk¬
Jet 500 output.
AppleWorks Add-Ons 18
• Current version numbers for Vitesse
and Seven Hills Software.
My Favorite Template 19
• A medical insurance and tax tracking
template.
AppleWorks News 25
• News and special offers from NAUG,
ActaSoft, America Online, Apple
Computer, Claris Corporation, Com¬
puter Literacy Press, Diskovery
Educational Systems, JEM, Marin
MacroWorks, Stone Edge Technolo¬
gies, and TimeOut-Central.
Data Base Tips 29
• Three commands that can improve
your labels.
Public Domain Updates 32
• New disks in NAUG’s Public Domain
Library.
Members Helping Members 34
• How to get help with Beagle Bros
enhancements.
Electronic Index Disk Update 35
NAUG Membership 36
NAUG Classifieds 36
Support for AppleWorks and III EZ Pieces Users
AppleWorks Forum
November 1991
Page 1
Letters to NAUG
Save Your UltraMacros Settings
Dear NAUG,
I use an UltraMacros-enhanced copy of Apple-
Works 3.0 and have to reactivate the mouse each
time I launch Apple Works. How can I save my
UltraMacros settings so the mouse automatically
becomes active?
Robert Neel
San Luis Obispo, California
[Ed: Launch an UltraMacros-enhanced copy of
AppleWorks and then follow these steps to make
the mouse active upon bootup:
1. Issue an Apple-Escape to access the TimeOut
Menu and select “Macro Options".
2. Select choice #8 (“Other Activities") from the
Macro Options Menu and press the Return Key.
3. Select choice #4 ( “Reactivate the mouse”) from
the Other Activities Menu and press the Return
Key.
4. Press the Escape Key to indicate you are done
setting the Other Activities settings.
5. UltraMacros will ask if you want to save the
new settings to disk. Respond by selecting
“Yes”.
The mouse will now be active when you launch
AppleWorks.]
@ f to m
Editor: Cathleen Merritt
Associate Editor: Warren Williams
Page Layout: Nanette Luoma
Publisher: The National AppleWorks Users Group
©COPYRIGHT 1991, by NAUG, The National AppleWorks Users Group,
for the exclusive use and enjoyment of its members. Any reprint or reproduction
must be approved in writing and in advance by NAUG.
The “Apple Works Forum ” (ISSN 0693-4118) is published monthly
for $31 per year by the National AppleWorks Users Group,
49066 Harvest Dr., Plymouth, Ml 48170.
Second Class postage paid at Plymouth, Ml, and additionaJ mailing offices.
POSTMASTER: Send address changes to AppleWorks Forum,
NAUG, Box 87453, Canton, Ml 48187
Problems with RamFAST Cards
Dear NAUG,
I think my fellow NAUG members should know
about the problems I experienced trying to use a
RamFAST high speed SCSI interface card. Specifi¬
cally, the card repeatedly damaged data stored on
my new Q-Drive by copying segments of two files
into the same block on the drive. These problems
disappeared when I reformatted the drive and used
my older (and slower) Apple SCSI card.
Although I miss the lightning fast speed of the
RamFAST, I will never recover the hours I lost try¬
ing to identify the source of my problems and
restore the data on the drive.
On the positive side, NAUG members looking for
extra memory should contact Charlie’s AppleSeeds
(9081 Hadley Place, San Diego, California 93126).
Chuck Newby sold me 70ns Goldstar chips at a
good price and gave me excellent service. Quality
Computers also gives me exceptional service on
everything I buy. Finally, I also recommend
NAUG’s Sider upgrade program from Omnishore
[Ed: See pages 27-28 of the August 1991 issue of
the AppleWorks Forum.]. Omnishore helped me
determine the best upgrade path for my system and
replaced my Sider drive with a new, improved 40
megabyte model at a reasonable price.
Pete Ross
Westland, Michigan
[Ed: NAUG has received five letters from mem¬
bers who lost data using a RamFAST interface
card. Although we applaud CV Technology’s
efforts to enhance the speed of the Apple II com¬
puter, we believe that data integrity and reliability
are more important than speed of operation. Mem¬
bers who expect high reliability from their hard
disk drive system should think carefully before
buying a RamFAST.]
The National AppleWorks Users Group (NAUG) is an
association that supports AppleWorks users. NAUG pro¬
vides technical support and information about Apple-
Works and enhancements to that program. Our primary
means of communicating with members is through the
monthly newsletter entitled the AppleWorks Forum.
Page 2
November 1991
AppleWorks Forum
Letters to NAUG,
Transferring Numeric Data
between Modules
Dear Cathleen,
I use Apple Works 3.0 to maintain my data base of
video tapes. Each month I print a tables format
report to the clipboard and use the AppleWorks
word processor module to add headings to the dif¬
ferent sections of the report.
I identify each tape by a series of numeric codes
separated by commas or dashes. However, Apple-
Works eliminates the “punctuation” when I print to
the clipboard and import the records into the word
processor. (For example, “34,35” becomes “3435”
and “34-36” becomes “3436”.) AppleWorks
replaces other strings of numbers with a series of
pound signs (“####”).
Is there any way to tell AppleWorks not to change
the data in the report?
James Gibson
Indio, California
[Ed: Jim, I think the problem goes back to the
instructions you gave when you designed the data
base report format. Specifically, I think you issued
an Apple-J command to tell AppleWorks to right
justify the data in the “codes” category. Unfortu¬
nately, that command also tells AppleWorks to
treat all numeric entries as numbers. Since Apple-
Works doesn’t expect to find hyphens and commas
within numbers, it drops the “punctuation”.
The pound signs in your report appear because the
column is narrower than the number you want to
print in that column. Although AppleWorks trun¬
cates text strings that are too long for a report, the
program replaces numbers that are too large with
pound signs.
I suggest that you get the offending report format
on the screen, put the cursor in the codes column,
and issue another Apple-J to turn off justification.
AppleWorks will then treat all your entries as text
strings and will not modify the data or substitute
the pound signs.]
Is this a Test?
Dear NAUG,
The July 1991 issue of the AppleWorks Forum did
not include the Electronic Index Disk update that I
use to maintain my electronic index to all the arti¬
cles in the newsletter. This is the second time
NAUG didn’t include the Electronic Index Disk
update. Are you leaving out the index to see if we
are paying attention?
Michael Cangi
Franklin, Massachusetts
[Ed: I wish everyone shared your sense of humor
about our omission of the Electronic Index Disk
update, Mike. We’ll make certain we include the
index in every future issue.
NAUG members can download the complete index
from the Electronic Forum (NAUG’s bulletin
board service) or from the NAUG areas on Com¬
puServe, GEnie, or America Online. You can also
order the Electronic Index on either one 3.5-inch
disk or two 5.25-inch disks from the NAUG Public
Domain Library. The cost is $6 plus $2 s/h.]
You can exchange AppleWorks data files with the most popular
MS-DOS programs:
WordPerfect
dBase III & IV
“...Look no further. SoftSpoken’s ^ H
CROSS-WORKS carries the biggest , ^
stick in the file translation/
transportation business... ^ ^ Vs*s^
Rating:
CROSS-WORKS 2.0 copies files either way between your Apple II
and IBM PC, and translates the file formats. Word processor files
maintain underlining, centering, etc. Spreadsheets keep data and
formulas! Transfers ASCII text files, too. Includes 19,200 baud
cable to connect lie (with Super Serial Card), lie , llcPIus, & llgs to
IBM PC, XT, AT, PS/2 & compatibles (no modem needed). Also
supports long-distance modem transfers. Works with AppleWorks
1.0 through 3.0. Includes 514 and 314 inch disks.
CROSS-WORKS ™ 2.0 $99 95 + shipping SoftSpoken
30 Day money-back satsifaction guarantee p 0. BOX 18343
® (919) 870-5694 for free information. Raleigh, nc 27619
AppleWorks Forum
November 1991
Page 3
Novice Notes
Our Ten Favorite
AppleWorks Tips
by Warren Williams and Cathleen Merritt
Figure 1: Word Processor Template
James Doe
123 Anywhere Street
Somewhere, US 12345
A
[Recipient]
[Address]
[Address]
[City,State,Zip]
Dear Sir or Madam:
On [date] I placed a telephone order for [item] from your
catalog and charged the payment to my MasterCard. As of this
date, I have not received the item nor word of when it
should arrive.
Please notify me as
to the status of this order.
Yours truly,
James Doe
I f you stretch your imagination, you
can find some commonality between
paper clips and AppleWorks. Although
both were developed to serve specific
functions, both now serve purposes
never imagined by their inventors. Like
the long-forgotten inventor of the paper
clip, the creator of AppleWorks left it
for others to discover ways to use the
flexibility of his program.
In the six years since its foundation,
NAUG has published more than 1,000
articles filled with tips, work-arounds,
and suggested applications for the pro¬
gram. Here are our favorites; some are
documented in the AppleWorks manu¬
als, others are not.
I. Develop and Use Templates
A template is an incomplete word pro¬
cessor document, data base, or spread¬
sheet that can serve as a model for your
work. Templates provide a structure for
a letter, report, spreadsheet, or other
AppleWorks application.
To develop a word processor template, you prepare
an incomplete document that you store in a file. For
example, the template in Figure 1 is the framework
for a letter of complaint you could send to a mail
order company. To complete the letter, you change
the name of the file (so you don’t overwrite the
original template on the disk), replace the appropri¬
ate lines with the recipient’s name and address, and
enter the item description and date you placed your
order. The caret mark ( A ) after the letterhead repre¬
sents the use of AppleWorks 3.0’s Print Date func¬
tion; AppleWorks will replace the caret mark with
the current date when you print the document.
Although word processor templates can ease your
work, it is the spreadsheet environment that shows
the true strength of templates. You can develop or
buy generalizable templates for almost any applica¬
tion. You load the template on the AppleWorks
desktop, change the file name, and enter your data.
The formulas built into the template do all the work.
Figure 2 presents a small segment of the
1040Works tax templates on the AppleWorks
screen. These are professionally developed tem-
Page 4
November 1991
AppleWorks Forum
Novice Notes..
Figure 2:1040Works Template
14| FORM 1040 SIDE 1 - REPORT, 1990
151-
161 Single, Line 1
171 FILING STATUS Married Filing Jointly, Line 2
181 (Check box on IRS fora) Married Filing Separately, Line 3
191 Head of Household, Line 4
201 Qualifying Widow (er), Line 5
211 -
221 7 Wages, salaries, tips, etc.7. 0.00
231INCOME 8a Taxable interest incane.8a. 0.00
241 8b Tax-exempt interest income.... 8b. 0.00 XXXXXXXXXXXX
251 9 Dividend incane.9. 0.00
261 10 Taxable refunds of state/local taxes.10. 0.00
271 11 Alimony received.11. 0.00
281 12 Business income or (loss) from Sched C_12. 0.00
291 13 Capital gain or (loss) from Sched D.13. 0.00
301 14 Capital gain distrib not on Ln 13.14. 0.00
311 15 Other gains or (losses).15. 0.00
AN14:
Type entry or use (5 commands 328K Avail.
Type entry or use (5 commands 328K Avail.
plates that use Apple Works’ spreadsheet module to
compute your Federal Income Tax liabilities and
print the necessary tax forms.
You should try to think of template applications for
every document or file you create.
II. Install Multiple Printers in AppleWorks
AppleWorks lets you add up to three printers to its
Printer Menu. Power users need that capability;
they often have more than one printer connected to
their Apple II system. However, most of us use one
printer, and list only that printer on our Apple-
Works Printer Menu.
We suggest that you tell AppleWorks that you have
three printers, even if you have only one. By
installing three different configurations of your
printer in AppleWorks, you can store up to three
different configurations for that printer. For exam¬
ple, you can define one printer as a “Single Sheet
Printer”. All you do is add the printer to the menu a
second time, name it “Single Sheet” and change the
“Stop at the end of each page” setting to “Yes”.
Then you can use either continuous feed or single
sheets of paper without reconfiguring your system.
This technique adds significant flexi¬
bility to AppleWorks. For example,
the AppleWorks 3.0 word processor
can store up to six Special Codes for
each printer. By adding additional
printers to AppleWorks you can
access up to eighteen codes instead
of the original six.
III. Use the Cursor Movement
Commands
We won’t list the 100+ improve¬
ments Claris made to version 3.0 of
AppleWorks, but we find that many
users have not discovered the new
cursor movement commands avail¬
able in AppleWorks 3.0. Figure 3
contains a list of those commands.
These commands make it easy to
move the cursor to any position on
the screen. We suggest that you
experiment with the commands until
they become second nature to you.
IV. Word Processor: Controlling Page Breaks
You are probably familiar with AppleWorks’ New
Page Command that lets you tell the program where
to start a new page. The problem with New Page is
that the command resides at a specific location in
your file. Each time you add or delete text, you
must remove and reinsert New Page Commands to
control the pagination of the edited document.
Fortunately, there is a better way to control the
page breaks in documents.
AppleWorks lets you define any block of text as a
“group” that the program will not split between
pages. If the entire block does not fit on the current
page, AppleWorks skips to the top of the next page
and prints the block together on that page.
You use the Group Begin and Group End Com¬
mands on the word processor Options Menu to
define the “group” (or “block”) of text. As you can
see from the example in Figure 4, inserting a
Group Begin Command at the beginning of a list
and a Group End Command at the end of the list
AppleWorks Forum
November 1991
Page5
Novice Notes
Figure 3: Cursor Movement Commands
Command
Word processor
Data Base
Spreadsheet
Apple-Right Arrow:
Next word
End of word/category/screen
Right one screen
Apple-Left Arrow:
Previous word
Beginning of word/category/screen
Left one screen
Apple->:
End of line
Last category
Last used column
Apple-<:
Beginning of line
First category
First used column
Apple-Return:
Beginning of next line
Apple-Tab:
Next tab marker
Previous category
Left one cell
Control-Tab:
Previous tab marker
Apple 1-9:
First/last line
First/last record
First/last row
Figure 4: Using Group Begin/Group End
File: ARTICLE
REVIEW/ADD/CHANGE
Escape: Main Menu
===<==<==<=
and should consider the following points when writing user documentation:
-Indent: 4 chars
--Group Begin
1. State your objectives or purpose early in the body of the text.
2. Make certain your readers understand the context for the points you make
in that section of the document.
3. List any required equipment, software, and supplies before starting on
the step-by-step procedures.
4. Include all step-by-step descriptions within numbered paragraphs.
-—Group End
-Indent: 0 chars
One of the most difficult parts of writing is to first tell the readers
everything they need to know without digressions. You will be tempted to tell
them either too little (because it is tedious to write every detail) or too
much (by telling them all the tricks you've learned). The tricks are
Type entry or use (5 commands
Line 22 Column 1
52K Avail.
insures that AppleWorks will not insert a page
break in the middle of the list.
You will find many uses for the Group Begin/End
Commands. For example, teachers can control the
page breaks in tests by putting each test item with¬
in its own pair of Group Begin/End Commands.
Writers can ensure that headings do not print by
themselves at the bottom of a page by putting a
Group Begin Command before each heading and a
Group End Command at the end of the following
paragraph.
V. Data Base: Create 30 Categories
AppleWorks’ data base module lets you add and
delete categories from a file whenever you want;
even after you enter data into the
file. However, AppleWorks cannot
redesign its custom screen layouts or
report formats when you add or
delete categories. Instead, the pro¬
gram loses those formats whenever
you change the internal category
structure of a file. Thus, there is
good reason to avoid adding or
deleting categories after you start
working with a data base.
Although adding or deleting cate¬
gories destroys your custom screens
and printed reports, AppleWorks lets
you change existing category names
without penalty. Therefore, the trick
is to create thirty categories in every
data base file and never add or
delete categories in that file.
You can assign any name you want
to the extra categories and then use
the Apple-N command to rename
the categories when you need them. We name the
extra categories so they do not take up much
room on the AppleWorks screen.
Since you always want to maintain thirty cate¬
gories, you should never delete a category from a
file. Instead, use the Apple-N command to change
an unwanted category name back to and
remove all the data from that category.
The easiest way to remove the data is to show the
category on the multiple record layout screen,
blank the first record by entering an Apple-Y, and
using Apple-” (see Tip VII below) to copy the
blank data into all the records in the file.
Page 6
November 1991
AppleWorks Forum
Novice Notes
VI. Data Base: Customize the Single
Record Layout
Apple Works makes it easy to create
a new data base: You simply enter
the category names and start enter¬
ing data. The program automatically
creates the familiar “default” Insert
Records and Single Record Layout
screen that appears in Figure 5.
Although many users keep the
default format, AppleWorks offers
an Apple-L command that lets you
customize the screen so it looks like
the example in Figure 6.
The arrangement of the categories in
Figure 6 is more readable, lets you
make longer entries in the address
categories, and puts the extra cate¬
gories at the bottom of the screen
where they are less intrusive.
To customize the single record lay¬
out, get a record on the screen in
Review/ Add/Change mode and
issue an Apple-L. (AppleWorks
“beeps” if you enter an Apple-L in
Insert Records mode. Press the
Escape Key and then issue an Apple-
L if your computer beeps.) Then you
can move the categories around the
screen with the same keystrokes you
use to develop a labels format report.
Press the Escape Key when you are
done and select “Left to right, top to
bottom” as the desired direction for
cursor movement.
Step-by-step directions for customiz¬
ing the single record layout appear in
the AppleWorks documentation and
in the article entitled “How to Get
Started with the Data Base Module”
in the November 1989 issue of the
AppleWorks Forum.
INSERT NEW RECORDS Escapa: Raview/Add/Changa
Record 13 of 57 (8 selected)
FNAME: -
LNAME: -
ADDRESS1
ADDRESS2
CITY: -
STATE: -
ZIP: -
PH0NE1: ■
PH0NE2: ■
134K Avail
INSERT NEW RECORDS Escape: Review/Add/Change
Record 13 of 57 (8 selected)
FNAME
LNAME
ADDRESSl
PH0NE1
PH0NE2
127K Avail
AppleWorks Forum
November 1991
Novice Notes ...
VII. Data Base: Use Apple-V and Apple-"
AppleWorks offers two keystroke commands that
make it easy to enter repetitive data into many
records. The Apple-V command lets you create
default entries that automatically appear in all new
records. The Apple-" command copies data
between existing records.
You use Apple-V when you can predict the entries
in one or more categories for all new records you
will add to your file. For example, a business that
draws most of its customers from a single city can
use the Apple-V command to enter the city and
state as default entries for all new records.
You use Apple-" to add data to existing records.
For example, to change the ZIP code for everyone
who lives in a certain city or to put “USA” in all
the records in a file.
Note that Apple-V and Apple-" serve different
functions. Apple-V inserts data into new records; it
does not affect existing records. Apple-" inserts
data into existing records; it does not affect new
records.
Step-by-step directions for using the
Apple-V and Apple-" commands
appear in the AppleWorks documen¬
tation.
VIII. Data Base: Print Category
Names on Labels
The Apple-V command, which lets
you insert default entries in new
records, serves an unrelated but use¬
ful function when you prepare a
labels format report. Specifically,
Apple-V tells AppleWorks to print
the category name and the data on
each label.
To print the category name, get the
labels format report on the screen,
put the cursor on the first letter of
the category name, and enter an
Apple-V. AppleWorks will display
the category name, a colon, and then
sample data taken from the first
record in the file.
Figure 7 demonstrates an application of Apple-V.
This example shows a report that prints a label a
druggist could put on a bottle that contains a pre¬
scription medicine. In this case, the druggist used
Apple-V commands to tell AppleWorks to print the
category names “Dr.”, “Qty”, “Expiration Date”,
and “# of Refills” on each label.
For more examples that use Apple-V in labels for¬
mat reports, see the article entitled “Three Com¬
mands that Can Improve Your Labels” on page 29
of this issue of the AppleWorks Forum.
IX. Spreadsheet: How to Enter Long Formulas
AppleWorks’ powerful spreadsheet module
encourages users to develop increasingly complex
spreadsheet templates and models. Many of these
applications include formulas that use the branch¬
ing and text-manipulating capability provided by
AppleWorks’ (©LOOKUP, @IF, and (©CHOOSE
functions.
Unfortunately, these operations often involve
lengthy formulas, and there is a limit to the length
and complexity of the formulas you can enter into
File: PRESCRIPTIONS
Report: Bottle Label
Selection: All records
REPORT FORMAT
Patient 1
Date 1
Brand Name :
Generic \
Dosage
Warnings
Expiration Date: JUl 1 92
Note
# of Refills: 1
8 lines-
Use options shown on Help Screen
226K Avail
Page 8
November 1991
AppleWorks Forum
Novice Notes...
Figure 8: Template for Printing on Forms
AppleWorks. Here are two tech¬
niques you can use when you reach
those limits:
1. AppleWorks inserts “Value: ” or
“Label: ” in front of each entry
when you enter a formula or
label. As a result, the program
will only accept up to 70 charac¬
ters in a formula. Fortunately,
AppleWorks lets you enter up to
77 characters when you edit the
formula.
Try typing a part of the formula
and pressing the Return Key to
enter the formula into the spread¬
sheet. (Your partial formula must
be “legal”, otherwise Apple-
Works will beep and reject your
entry.) Then issue an Apple-U
command to bring the formula
back onto the Edit Line and com¬
plete your entry.
2. Replace a series of arithmetic or logical opera¬
tions in the formula by referring to a “working
cell” that does those operations. For example,
you can shorten the formula
@IF(@SUM(B1...B10)>100,"BUY", "HOLD") tO
@if(bii>100, "buy", "hold") if you store the sum of
B1 through BIO in B11. In this example, cell
Bll serves as the “working cell” that stores the
sum used in the longer @IF formula.
X. Use the Mail Merge Module to Fill in Forms
Ever wonder how to use your data base file to fill
in pre-printed forms? The trick is to use Apple-
Works’ mail merge module. Follow these steps:
1. “Print” any subset of your data base file “To the
clipboard (for mail merge)”.
2. Use a ruler to determine the location of each
blank on the pre-printed form. Define each
location as the number of lines down the page
and spaces from the left margin of the page.
3. Create a word processor template that uses a
Left Margin Command to place the first cate¬
gory at the correct position on the line and tabs
to position the remaining mail merge fields.
The tabs insure that each field will print at the
same location on every form.
Your completed template should look like the
example in Figure 8.
Conclusion
We offer these tips and suggestions to the Apple-
Works community with some trepidation. No doubt
you have different, and perhaps more significant,
favorites. So now it is your turn. Send your
favorites to “My Favorite Tips”, NAUG, Box
87453, Canton, Michigan 48187.
[Warren Williams is a Professor of Educational
Technology at Eastern Michigan University and
President of the National AppleWorks Users
Group.]
[Cathleen Merritt is Director of the National
AppleWorks Users Group and Editor of the Apple-
Works Forum.]
AppleWorks Forum
November 1991
Page 9
Software Review
Magic File Cabinet Expands
AppleWorks’ Data Base
by Leon H. Raesly
I f you ever wanted to store unstructured notes,
comments, or other long strings of characters in
an AppleWorks data base file, you should know
about Magic File Cabinet (MFC). MFC uses Time-
Out UltraMacros to link a data base file with a
word processor document. Then MFC accepts long
strings of text in word processor “records” linked
to the original data base file. This clever linkage of
the AppleWorks data base and word processor
modules accepts information that does not normal¬
ly fit in a data base record.
It is difficult to over-state the possible uses for this
product. For example, MFC lets you attach lengthy
notes about telephone conversations to the name
and address of the person you called. That same
record can also include detailed directions to that
person’s house and the names of the other members
of his or her family.
Business owners can use MFC to store descriptive
information about clients, products, and invento¬
ries. Teachers can keep a directory of handouts and
tests in a data base file and store the actual docu¬
ments in linked word processor records. Seven sets
of sample files on the MFC disks demonstrate dif¬
ferent applications for this highly useful accessory.
How It Works
MFC links your existing or specially designed data
base file with a word processor document with the
same name prefixed by “W.” (For example, MFC
links a data base file called “LEE.LIST” with a
word processor file called “W.LEE.LIST”.) You
then use the special MFC commands to jump
between the linked records in your data base and
word processor files.
The new commands are easy to learn. For example,
the <sa-F> (Find) and <sa-G> (Go Back) com¬
mands jump between the data base and word pro¬
cessor records. MFC also offers an on-line help
menu that reminds you of the keystroke options.
Getting started with MFC involves copying two
task files into the subdirectory that contains your
working copy of AppleWorks and launching one of
those files. Then you can use the tutorial to learn
how to design your data base files and how to use
the commands MFC adds to AppleWorks.
The MFC package includes a Quick Start instruc¬
tion sheet to help you get started and either a 5.25-
inch or 3.5-inch disk which includes the MFC task
files and seven sets of sample files. The disk also
includes a 16-page tutorial, and an Ideas file that
contains a four page list of ideas and suggested
applications for MFC.
The comprehensive, well-written, and sometimes
humorous tutorial walks you through the opera¬
tions necessary to get comfortable with the pack¬
age. Although the MFC commands are easy to
learn and remember, beginners should spend 30-45
minutes doing the tutorial so they learn the concept
behind the program and applications for its use.
MFC is a stable product; it never locked up my
computer, dropped my system into the monitor, or
lost any data.
The program does impose two minor limitations.
First, it limits you to 28 categories in a MFC data
base because MFC reserves two categories to link
your data base and word processor files.
Second, there is no direct way to print the associat¬
ed data in the linked data base and word processor
Limitations
Documentation and Ease of Use
Page 10
November 1991
AppleWorks Forum
Software Review.
A Different Technique
The Magic File Cabinet documentation suggests that
you put MFC’s two special data base categories
(“REF#” and “*”) at the end of the single record layout
and at the beginning of the multiple record layout. That
lets you enter data in new records without having to
skip over the MFC-specific categories.
However, I prefer to keep the multiple record and single
record categories in the same order, so I do not rearrange
the categories in these layouts.
One of the advantages of MFC is the flexibility it gives
you in deciding how to structure your files and manage
your data; I suggest that you take advantage of that flexi¬
bility and customize the files to reflect your own style
and preferences.
You’ll Use It Often
If my experience is a guide, you will use Magic File
Cabinet more often than you expect. I now design
every data base file so it is compatible with MFC.
Inevitably, I find myself using MFC to expand upon the
data in the file.
Consider developing a data base template you can use to
build MFC-compatible data base files. The template
should contain 30 categories. Name the first and second
categories “REF#” and respectively; assign any
name you like to the remaining categories in the tem¬
plate. Then use the template each time you need to
design a new data base file.
records. You can use TimeOut ReportWriter to cre¬
ate reports or documents that link those records,
however ReportWriter is only appropriate for more
advanced Apple Works users. The rest of us can
overcome this limitation by printing directly from
the AppleWorks word processor using the “Print
from the cursor” and “Print this page” options.
Alternatively, you can use AppleWorks’ Apple-H
command to print the contents of a data base
record and the linked word processor data.
Conclusion
Magic File Cabinet uses TimeOut UltraMacros to
overcome AppleWorks’ inability to manage free
flowing text in a data base record. It is an easy-to-
use enhancement that adds important functionality
to AppleWorks. MFC’s low $15 price makes it an
exceptional value.
[Magic File Cabinet requires AppleWorks 3.0
enhanced with TimeOut UltraMacros 3.1 or later.
MFC lists for $15 plus $2 s/h (Maryland residents
add $.85 tax) from Magical Software, 8255 Can¬
ning Terrace, Greenbelt, Maryland 20770; (301)
345-3230. Until January 31,1992 NAUG members
can buy MFC directly from the developer for $10
plus $2 s/h. (Maryland residents add $.60 tax.)
Identify yourself as a NAUG member and include
your NAUG membership number when you order.
Magical Software promises “satisfaction guaran¬
teed or your money back”.]
[Leon Raesly is a Licensed Clinical Social Worker
and is Director of Mental Health Associates, a
mental health agency that uses four Apple IIgs and
several Apple lie computers to manage all its busi¬
ness operations. Mr. Raesly is also a Director-at-
Large of the Washington Apple Pi User Group.]
FAMILY TREE
A GENEALOGISTS PROGRAM
1 Let FAMILY TREE automatically link together your
j family's history into a fast, fun, low priced, and
| extremely easy to use database Documentation is
1 on the disk, along with many help screens and
friendly prompts. FAMILY TREE automatically
| creates a wide variety of charts, group sheets,
1 AppleWorks WP and DB files, and much more.
I FAMILY TREE even determines relationships!
Automatic conversion of LDS PAF data files is
provided. No doubt about it, this is a BEST BUY in
1 genealogy software for the Apple lie (enhanced), lie,
K lie + and IIGS. FAMILY TREE will install itself onto
% your hard drive or /RAM disk (500K or larger) if
S you desire. Includes a 30 day money-back satis-
1 faction guarantee!!! SASE for more information.
For a copy of the latest version (please specify 3 5 or 5 25 inch
disk) send $39 95 (includes US postage - for foreign postage please
add $5) Registered owners may upgrade, at any time, for $10
* California residents please add appropriate Sales Tax
Phone 005 - 684-3366 (info only - no phone orders)
Hours 9 AM to 1 PM (Pacific Time) Monday thru Saturday
Robert M. Merrill
6180 Uia Real, *.25
Carpinteria, Ca 93013-2863
AppleWorks Forum
November 1991
Page 11
My Favorite Macro
Macros that Modify AppleWorks
by Barclay Clemesha
T he primary function of a macro program is to
automate the execution of a sequence of key¬
strokes. However, it is UltraMacros’ built-in pro¬
gramming language, not its ability to capture key¬
strokes, that gives the program much of its power.
Of course, UltraMacros lets you write macro pro¬
grams with integer arithmetic, conditional branch¬
ing, and subroutines. The programming language
also offers a <call> command that lets you call
internal AppleWorks subroutines and a <poke>
instruction that lets you store machine language
routines in unused portions of memory.
This article describes how to use those capabilities
to insert mousetext characters directly into word
processor documents without using the normal
AppleWorks input routines. You can also use these
techniques to insert embedded print format¬
ting commands (e.g., subscript, superscript,
or special codes) without accessing Apple-
Work’s Options Menu.
Figure 1 contains examples of the output
you can generate once you master the tech¬
niques described in this article.
These macros use <poke> statements to store
a short machine language routine in a small
area of memory. Although these memory
locations are not used by AppleWorks, Ultra-
Macros, or Outliner, they are widely known to
AppleWorks developers and might be used by other
AppleWorks enhancements. If AppleWorks crashes
after you run these macros, you will have to do
some detective work to determine the source of the
conflict so you can choose between the macros in
the article and the conflicting enhancement. Also
check your typing; a typing error can poke incorrect
data into memory and cause AppleWorks to crash.
The Word Processor Work Register
AppleWorks stores the current word processor line
in a work register starting at memory location
$7B00. The first byte in that register, at $7B00,
gives the offset of the first character on the screen.
(That value is a zero unless you have non-standard
margins or indent.) The byte at $7B01 gives the
offset of the last character in the line. The actual
data bytes for the line start at $7B02.
You might think that all you need do to modify the
line is to poke the required character code into the
appropriate memory position. For example, a macro
containing the instruction <poke $7B02,193>
should change the first character of the current line
to an Open-Apple symbol. However, things are
never quite as simple as they first appear.
Although AppleWorks stores the current line at
$7B00, it keeps the same information in memory
along with the rest of the document. AppleWorks
uses the StoreLine subroutine
that starts at address $6E1A to
update the document in memory
so it reflects the changes you
make in the work register. Thus,
you must force AppleWorks to
execute the StoreLine routine
after you change the contents of
the work register so the program
remembers your changes.
AppleWorks provides a convenient “hook” (called
“AfReadTest”) at $100C which normally sends
AppleWorks off to the UltraMacros routines at
$B80B (assuming UltraMacros is installed). The
<ba-g> macro in Figure 2 modifies the jump
instruction in the AfReadTest routine so it branches
to the StoreLine subroutine at $6E1A before jump¬
ing to UltraMacros at $B80B.
The pokes in the macro change the JMP $B808
instruction found at $100C to a JMP $0A50 and
also poke in a routine at $0A50 (where Apple-
Works leaves 128 bytes of memory free). That rou-
u These techniques
let you print sym¬
bols not normally
accessible within
AppieWorks. ,,
The Macros
Page 12
November 1991
AppleWorks Forum
My Favorite Macro ...
Figure 1: Sample Outputs
With an Epson printer and the mouse macro you can make some
neat boxes....
Neat Box
□r Fancy forms
Just the
Thing for making fancy
Forms
mil
You can write some impressive looking equations....
es
2 71
$2 2( p + ct )2 d$
Or write French with the proper accents.
Vive la difference!
All straight from AppleWorks, without SuperFonts.
Figure 2: Macros that Patch AtReadiest and Call StoreLine
<ba-g>:<asr :
{ Patch that calls StoreLine.
i
pokeword 2640,$008D :
pokeword 2642,$8E08 : { Poke the machine language program at $A80.
)
pokeword 2644,$0801 :
pokeword 2646,$028C :
pokeword 2648,$Ad08 :
pokeword 265O,$0A74 :
pokeword 2652,$0Af0 :
pokeword 2654,$00A6 :
pokeword 2656,$1A20 :
pokeword 2658,$A56e :
pokeword 2660,$8D00 :
pokeword 2662,$0A74 :
pokeword 2664,$00AD :
pokeword 2666,$AE08 :
pokeword 2668,$0801 :
pokeword 267O,$02AC :
pokeword 2672,$4C08 :
pokeword 2674,$B80B :
pokeword $100C, $504C
: poke $100E, $0A>! { Change AfReadTest hook.
)
<ba-ctrl-g>:<asr :
{ Restore normal AfReadTest.
i
pokeword $100C, $0B4C
: poke $100E, $B8>!
tine saves the microprocessor registers, stores a the microprocessor registers and jumps to Ultra¬
zero in variable x, and calls $6E1A. On returning Macros at $B808.
from the StoreLine subroutine, the patch restores ^ n . . . . a i vir i _ c
r Once you install this patch, AppleWorks transfers
AppleWorks Forum
November 1991
Page 13
My Favorite Macro...
Figure 3: Macros that Insert Mousetext Characters
<ba-?>:<asr :
{ Insert any byte z in the work register.
i
ba-g : ctrl-A : left :
{ Poke the machine language program and fix the hook.
)
x = peek #curhor + $7B02 - peek $7B00 :
{ Store the location of the character under cursor into
X. }
poke x, z : poke $A74, 1 :
{ Poke the code into the work register.
}
right : ba-ctrl-g>!
{ Restore the original hook.
}
<sa-esc>:<awp :
{ Type mousetext in directly.
1
key = key :
{ Get the code from the next keystroke.
}
if key = 27 : stop : else :
{ Quit if user pressed Escape.
}
z * k+128 : ba-? :
{ Add 128 and call ba-?.
}
spc : del : rpt>!
{ Force screen update and repeat.
}
everything you poke into the work register into the
current desktop document as soon as it receives
input from UltraMacros.
Note that the routine calls StoreLine only if it finds
a non-zero value at $A74. Since the macro zeros
this byte when it returns from the subroutine, you
must poke a non-zero value into $A74 every time
you want to store a character. That insures that you
only call StoreLine when you need it.
Even with this precaution, it is wise to restore the
normal branch instruction at $100C as soon as you
finish inputting “illegal” characters; that is the
function of macro <ba-ctrl-g>.
Insert Characters into the Work Register
To insert characters into AppleWorks, you need a
macro which calls <ba-g>, pokes the required char¬
acters into the work register starting at $7B02,
sends a <right> command to AppleWorks, and then
calls <ba-ctrl-g>. (The <right> instruction forces
AppleWorks to go through AfReadTest and thus
jump to the correct subroutine.)
Figure 3 contains two macros that perform these
functions.
The <sa-esc> macro in Figure 3 stores a keystroke
in z, adds 128 to the value of the keystroke, and
calls <ba-?>. The <ba-?> subroutine calls <ba-g>,
prints an Apple Token (Control-A), replaces it with
the character having the ASCII value of z, moves
the cursor one character to the right, calls <ba-ctrl-
g>, and returns to <sa-esc> which loops back for
more input. Note that the Control-A generates an
Apple Token that appears as a caret on the screen
and is identified as “Apple” when you put the cur¬
sor on the caret. It is a convenient “do nothing”
character.
As a result, everything you type after you press an
<oa-esc> goes into the word processor with the
high bit set. Thus, upper case letters and the char¬
acters “[“ through “-” appear as mousetext, lower
case letters are highlighted, and other characters
appear as carets. You must press the Escape Key to
return to normal typing.
If you use many macros, put the <asr> subroutine
macros near the beginning of the table. Otherwise,
you will experience a delay when you type mouse-
text.
Enhanced Printing
The techniques I described let you use mousetext
to enhance your on-screen documentation with
underlined titles, boxes, text dividers, and high¬
lighted lower case letters. A variant of this
approach lets you enhance your printouts.
For example, I use this technique to access the
extended character set in my Epson printer. That
lets me print mathematical symbols, Greek and
accented letters, and boxes. Examples of the output
appear in Figure 1. Most other printers support
extended characters sets with similar features.
To access the extended character set you must send
the printer interface an initialization string that lets
it respond to codes with the high bit set. (The cor¬
rect sequence is “ctrl-I H ctrl-10N” for my Epson
interface card, but you will have to find the appro¬
priate settings in the manual that came with your
interface.) Unfortunately, some older parallel cards
cannot send high bits to the printer; you will have
Page 14
November 1991
AppleWorks Forum
My Favorite Macro ...
Figure 4: Embedded Print Command
Codes
Function
Code
Boldface Begin
1
Boldface End
2
Superscript Begin
3
Superscript End
4
Subscript Begin
5
Subscript End
6
Underline Begin
7
Underline End
8
Print Page Number
9
Enter Keyboard
10
Sticky Space
11
Mail Merge
12
Print Date
14
Print Time
15
Special Code 1
16
Special Code 2
17
Special Code 3
18
Special Code 4
19
Special Code 5
20
Special Code 6
21
Tab Token
22
Nothing
23
Apple Token
24
Note: AppleWorks will lock up if you enter codes 25
through 31
Figure 5: Macro that Inserts
_ Superscript Commands
<sa-up>:<awp: { Define the macro. }
z = 3 : ba-? : { Insert superscript begin. }
z = 4 : ba-? : { Insert superscript end. }
left>! { Move cursor between the commands. }
to replace those cards to get the output that appears
in Figure 1.
Quick Keys
You can also use this approach to create “quick
keys” that enter embedded print commands with a
single keystroke, much like the Control-L com¬
mand turns underlining on and off from the key¬
board. All you do is write a macro for each code
that sets z equal to the appropriate value and then
calls <ba-g>. Figure 4 lists the codes AppleWorks
uses for the embedded print commands.
The <sa-up> macro in Figure 5 demonstrates an
application of this technique. That macro inserts
Superscript Begin and Superscript End Commands
and puts the cursor between the commands ready
to accept the superscripted characters.
Conclusion
The techniques described in this article let you dis¬
play mousetext on the screen and print a wide vari¬
ety of symbols not normally accessible within
AppleWorks. These procedures also let you enter
embedded print commands directly into a document.
With a little ingenuity, I believe you will think of
other uses for these techniques.
[Barclay Clemesha is an atmospheric physicist
with the Brazilian Space Research Institute. He
writes Apple II software in his spare time.]
Corrections
August 1991, page 6, step #3B should read “Modify the tab
ruler and set a left tab at the beginning of each column.”
October 1991, page 27, Figure 1. The first line in the macro
Should read <ba-c> : <awp $0="Macro Options" :
ASSET ANALYSIS
The only totally integrated AppleWorks Asset
Management Spreadsheet for the Apple II
“[Asset Analysis is]... a truly powerful program
for the serious investor.” -inCider/A+, March ’91
Asset Analysis makes it easy to compute and determine:
- Your real wealth accumulation.
- Your investment at risk and current amounts.
- Your gain (loss), % gain (loss), % annual and total return for each
asset, each portfolio, and for all assets. Total integration.
Calculations are quick and accurate and printing is easy.
Compatible with all versions of AppleWorks, AppleWorks GS, and all
Apple-compatible computers.
Satisfaction guaranteed or your money back.
Asset version E 2.1.1 (3.5" disk, 218K desktop) $44.00
Asset version V 2.1.1 (5.25" disk, 132K desktop) $40.00
Prices include 20% NAUG member discount.
FrankSoft Publishing Order from the Publisher
3300 33rd Avenue Court No shipping & handling
Rock Island, IL 61201 Visa/MasterCard
(309) 788-6330 Illinois residents add 6.75% sales tax
AppleWorks Forum
November 1991
Page 15
Software Review
SuperPatch Offers Exceptional
DeskJet 500 Output
by Marty Knight
R ich Brossman concluded his
August 1990 review of the
Hewlett-Packard DeskJet printer by
stating that the DeskJet offers laser
quality output from Apple Works at a
reasonable price. That statement is
even more valid today, thanks to
SuperPatch 8.0, an easy-to-use, menu-
driven program that automatically
installs and deinstalls more than 300
patches that customize AppleWorks.
[Ed: See the article entitled “AW3
Companion and SuperPatch: Apple-
Works a la Carte” in the February
1990 issue of the AppleWorks Forum
for a comprehensive review of Super-
Patch.]
SuperPatch and the DeskJet 500
SuperPatch 8.0 includes patches that
install two DeskJet 500 “drivers” in
AppleWorks 3.0’s SEG.ER file. You
boot SuperPatch and go through the
menu-driven operation to install these
patches. Then you can use the drivers
to generate attractive printed output in
both portrait and landscape modes on
the page.
Figure 1 presents a sample of the out¬
put produced by a SuperPatched copy
of AppleWorks on a DeskJet 500
printer.
Total installation time is less than one
minute. (Note that installing the Desk¬
Jet 500 drivers deletes all other printers
from SEG.ER. Heed the warning in the
manual and save a copy of your
Figure 1: Sample Output from a DeskJet 500
Courier 10 cpi justified
Fourscore and seven years ago our
fathers brought forth on this continent
a new national conceived in liberty and
dedicated to the proposition that all
men are created equal. Now we are
engaged in a great civil war testing
whether that nation, or any nation so
conceived and so dedicated, can long
endure. 1
*******
Letter Gothic 12 cpi justified
Fourscore and seven years ago our fathers
brought forth on this continent a new national
conceived in liberty and dedicated to the
proposition that a77 men are created equal. Now
we are engaged in a great civil war testing
whether that nation, or any nation so conceived
and so dedicated, can long endure. 1
*******
Letter Gothic 24 cpi justified
Fourscore and seven years ago our fathers brought forth on this continent a new national
conceived in liberty and dedicated to the proposition that all men are created equal. Now we are
engaged in a great civil war testing whether that nation, or any nation so conceived and so
dedicated, can long endure. 1
*******
CG Times proportional 12 point
Fourscore and seven years ago our fathers brought forth
on this continent a new national conceived in liberty and
dedicated to the proposition that all men are created
equal. Now we are engaged in a great civil war testing
whether that nation, or any nation so conceived and so
dedicated, can long endure.'
Page 16
November 1991
AppleWorks Forum
Software Review...
SEG.ER file if you installed a custom printer into
AppleWorks.)
Features
The DeskJet portrait driver supports most of the
features available for the ROM based fonts built
into the DeskJet 500, including CG Times propor¬
tional (6 and 12 points); Courier 5, 10,16.67, and
20 cpi (6 and 12 points); Letter Gothic 12 and 24
cpi (6 and 12 points); italics; underline and double
underline; boldface, superscript, and subscript.
The DeskJet offers fewer features in landscape
mode. The SuperPatch landscape driver supports
Courier 10, 16.67, and 20 cpi (6, 12, and 24
points); italics; double high; boldface, superscript,
and subscript.
You invoke most of these features (e.g., boldface,
superscript, and subscript) by using the commands
built into the AppleWorks Options Menu. Other
features (e.g., italics and double underline) are
available through the Special Codes that Super-
Patch automatically installs in SEG.ER. You can
even combine commands to get special effects.
For example, you can produce half-height super¬
scripts by invoking the codes for six point output
and for superscript.
The SuperPatch disk includes sample files that
demonstrate how to use the printing features the
patches install into AppleWorks.
Support for Proportional Fonts
As you can see from Figure 1, a SuperPatched copy
of AppleWorks produces excellent proportionally
spaced output from the DeskJet 500. However, you
must live with two limitations. First, AppleWorks
often does not handle page breaks correctly if the
break occurs within a proportionally spaced para¬
graph that contains a Tab Command. [Ed: This is a
problem with AppleWorks 3.0 and occurs with most
printers that offer proportional output.]
Second, although a SuperPatched copy of Apple-
Works accepts commands to print fully justified
documents in a proportional font, your printouts
will have a ragged right margin and uneven spac¬
ing between words. This is because the DeskJet
does not support the commands necessary to dis¬
tribute the extra space evenly between words. [Ed:
See John Link’s description of “fractional justifi¬
cation” in his article entitled “Understanding
SEG.PR and SEG.ER” in last month’s issue of the
AppleWorks Forum.]
Conclusion
In conclusion, the SuperPatch DeskJet drivers are
excellent. They let DeskJet 500 owners access
almost all the DeskJet features from within Apple-
Works and generate laser-quality output at a frac¬
tion of the price of a laser printer.
[SuperPatch 8.0 normally costs $34.95from Qual¬
ity Computers, 20200 E. Nine Mile Road, Box 665,
St. Clair Shores, Michigan 48080; (800) 443-6697.
Until January 1,1992 NAUG members can buy
SuperPatch 8.0 directly from Quality for $19.95.
Identify yourself as a NAUG member when you
place your order. Registered owners of earlier ver¬
sions of SuperPatch can upgrade to version 8.0 for
$12. The upgrade includes a new manual.
Note that SuperPatch offers drivers for both Desk¬
Jet 500 and older DeskJet printers, however the
original DeskJets do not offer built-in proportional
fonts.]
[As this issue went to press, Hewlett-Packard low¬
ered the list price of the DeskJet 500from $729 to
$599. DeskJet printers are available at significant
discounts; make certain that you dealer determines
your cost based on the new, lower retail price.]
[Marty Knight teaches Computer Education at
Woodrow Wilson Middle School in Middleton,
Connecticut. Mr. Knight is the Apple II Productiv¬
ity Forum leader on American Online.]
AlphaCheck Plus
Family Finances
Runs inside AppleWorks v3.0
Runs inside AppleWorks v3.0
0 Double/Single entry bookkeeping
°Full financial and tax reporting
0 Personal/Business
0 Full financial & tax reporting
0 Check writing
0 Post to general ledger
° Budget, cash, and credit card
0 Check writing
posting
°Cash disbursement journal
0 All the accounting most people
0 Chart of accounts & vendors lists
ever need
°...and much more
NAUG Price: $39,95+$3.50 s/h
NAUG Price: $29.95+$3.50 s/h
ACTASoft
19700 Wells Dr., Woodland Hills, CA 91364; (818) 996-6731
AppleWorks Forum
November 1991
Page 17
Apple Works Add-Ons
Current Version Numbers for
Vitesse and Seven Hills Software
by Bruce Shanker
Figure 1: Vitesse Update Information
Current
Program
Version
Update Information
Bakkup
1.04
1.0 to current version - No charge
1.01-1.03 to current version - $3
Deliverance
1.1
1.0 to current version - $8
Exorciser
1.02*
$8 (includes update to Users Guide)
Renaissance
1.04
$3
Wings
1.04
$3
Quickie
2.03
1.0-1.02 to current version - $8
2.0-2.02 to current version - $3
Harmonie
2.0
No charge
♦Includes a faster Help routine; otherwise unchanged from ver¬
sion 1.01B.
Program
Current
Version
Update Information
SuperConvert
3.01*
$3
Registered SHRConvert owners: $20
Independence
1.0
Original version; no updates
GraphicWriter III
1.1
$3.50
Disk Access
1.0
Original version; no updates.
Font Factory GS
2.0
$16
Formulate
1.0
Original version; no updates.
♦Insignificant upgrade from version 3.0.
2310 Oxford Road, Tallahassee, Florida 32304;
Vitesse
Vitesse markets a complete line of Apple
II utilities including Bakkup (formerly
“Guardian”, a hard disk backup utility),
Deliverance (a file and disk recovery sys¬
tem), Exorciser (a virus checker). Renais¬
sance (a disk optimizer), Wings (a pro¬
gram launcher and set of utilities), Quickie
(a hand-held scanner and associated soft¬
ware), and Harmonie (a collection of
printer drivers for 16-bit programs includ¬
ing AppleWorks GS).
Figure 1 presents update information
about each Vitesse program. Send Vitesse
(a) your original disk, or (b) proof of pur¬
chase and an additional $1 with each
update request.
Seven Hills Software
Seven Hills Software markets GraphicWrit-
er III (a full-featured word processor), Font
Factory GS (a GS font editor that also con¬
verts Print Shop, Printrix, Beagle Write He
(MultiScribe), Publish It!, and Macintosh
fonts to GS fonts), Disk Access (a New
Desk Accessory that offers file manage¬
ment utilities that work with AppleWorks
GS and other 16-bit programs), SuperCon-
vert (that converts graphic images into GS-
compatible graphics), and Formulate
(which makes it easy to use mathematical symbols
in documents).
Figure 2 lists the current version number for each
Seven Hills package and the cost of updates.
[Vitesse Inc., Box 929, LaPuente, California
91747; (818) 813-1270. Seven Hills Software,
(904) 575-0566.]
[Bruce Shanker is a mathematics teacher at Kens¬
ington High School in Philadelphia (Pennsylva¬
nia). He is one ofNAUG’s Beagle Buddies and is
NAUG’s Vitesse Ambassador, Timeworks Ambas¬
sador, and Seven Hills Partner.]
Page 18
November 1991
AppleWorks Forum
AppleWorks Products Available from NAUG
The AppleWorks Handbook—Volume One: Contains
more than fifty articles that answer the most frequently
asked questions and solve common AppleWorks problems.
Topics include Word Processor Tips, Data Base Tips, Spread¬
sheet Tips, Disk and Space Management, “Printer Primer”,
and Ways to Use AppleWorks. Includes a foreword by Robert
Lissner, the author of AppleWorks. 214 pages; $16.95 plus
$2 s/h. (Members: $14.95 plus $2.50 s/h.)
The AppleWorks Handbook—Volume Two: The
authoritative “How To’ guide for AppleWorks. The handbook
includes 200 two- to five-page tutorials that illustrate the
step-by-step procedures required for dozens of AppleWorks
applications. Each article is important, concise, and well
written. No other book so effectively describes the full range
of AppleWorks functions and applications. 500 pages; $27.95
plus $3 s/h. (Members: $25.95 plus $3.50 s/h.)
The UltraMacros Primer: Tkaches you everything you
need to know to use TimeOut UltraMacros. This 259 page
manual is suitable for beginners and advanced users; it con-
Books
tains step-by-step instructions and dozens of useful sample
macros. The UltraMacros Primer describes applications for
both AppleWorks 2.x and 3.0, and includes a summary of the
commands available for AppleWorks 3.0.259 pages; $19.95
plus $3 s/h. (Members: $17.95 plus $3.50 s/h.)
How to Get Started with the Spreadsheet Module:
Thirteen lessons that teach you how to design and use
spreadsheets. This booklet also serves as an excellent tutori¬
al for a 1-3 week classroom unit on the AppleWorks spread¬
sheet module. 64 pages, 3-hole punched. $7.50 plus $1.75 s/h.
(Contact NAUG for significant discounts on multiple copies.)
How to Get Started with the Data Base Module: Four
easy-to-read lessons that describe how to create and manage
AppleWorks data base files, how to create and print reports,
and how to generate labels. An excellent instructional re¬
source to help learn or teach the AppleWorks data base mod¬
ule. 24 pages, 3-hole punched. $5.00 plus $1.50 s/h. (Contact
NAUG for significant discounts on multiple copies.)
Other NAUG Products
AW Wall Chart: A two-color, poster-size chart with the con¬
trol codes necessary to get more than 100 different printers
to work with AppleWorks. NAUG’s Wall Chart is an impor¬
tant resource for teachers and computer laboratory coordi¬
nators. $7.95, including postage. (Members: $6.95)
AppleWorks Command Cards: These two-color 6" x 8"
cards on heavy stock summarize all the AppleWorks com¬
mands. Use these reference cards with all your AppleWorks
classes. Package of 20. $5.95, including postage.
Electronic Index Disk: An electronic index of all the arti¬
cles ever printed in the AppleWorks Forum. You can
search for a title, an author, or a topic. It is easy to use, easy
to update, and includes references to articles in the Apple-
Works Handbooks. Specify 3.5" or 5.25". $6.00 plus $2 s/h.
Public Domain Catalog: This 44-page catalog describes
the valuable templates, enhancements, and utility programs
in NAUG’s Public Domain Library. Includes a $2 rebate cer¬
tificate valid on your first order. $5.00, including postage.
These audio tapes describe more than 100 useful Apple-
Works techniques and applications. The tapes are unique
because they are directed to users who are already familiar
with AppleWorks. According to inCider magazine, “Dr.
Williams’ easy, relaxed style on this audio tape makes it
simple for you to learn as you si Vat the keyboard or even
as you drive to work.” Each tape costs $9.95 plus $2 s/h
per order. (Members: $8.95). The complete set of five tapes
costs $45 (Members: $40) plus $2 s/h.
Tapes -
Word Processor: Tips and Techniques (60 minutes)
Word Processor: More Ideas and Techniques (60 minutes)
Data Base: Tips and Techniques (60 minutes)
Spreadsheet: Tips and Techniques (60 minutes)
How to Use the Features of AppleWorks 3.0 (90 minutes)
Satisfaction guaranteed or your money back.
AppleWorks Products Available from NAUG
TimeOut Enhancements
DeskTools: $29.95. (List: $49.95)
DeskTools II: $29.95. (List: $49.95)
FileMaster: $29.95. (List: $49.95)
GS Font Editor: $29.95. (List: $49.95)
Graph: $50.95. (List: $89.95)
MacroEase: $23.95. (List: $39.95)
Outimer: $39.95. (List: $69.95)
PowerPack: $29.95. (List: $49.95)
QuickSpell: $39.95. (List: $69.95)
ReportWriter: $45.95. (List: $79.95)
SideSpread: $29.95. (List: $49.95)
SpreadTools: $35.95. (List: $59.95)
SuperFonts: $39.95. (List: $69.95)
SuperFonts Activity Guide: $29.95. (List: $49.95)
SuperForms: $39.95. (List: $69.95)
TeleComm: $39.95. (List: $69.95)
Thesaurus: $29.95. (List: $49.95)
TextTools: $29.95. (List: $49.95)
UltraMacros: $35.95. (List: $59.95)
Shipping/handling: $3.50 for the first module; $2.50 each additional.
Other AppleWorks Enhancements
Companion Plus: Installs and removes more than 50 en¬
hancements to AppleWorks 3.0 and fixes ten AppleWorks
bugs. Includes TimeOut Pathologist, ToxtLoader Plus, Direc¬
tory Manager, and a patch that enhances the power of the
spell checker. (List price: $49.95.) $29.95 plus $3.50 s/h.
Point-to-Point: A powerful, full-featured, easy-to-use com¬
munications package. Uses the AppleWorks filecard screen.
Automatically converts AppleWorks files into ASCII during
transmission. (List price: $99.95) $59.95 plus $3.50 s/h.
InWords: InWords makes it easy to scan any typed or print¬
ed document into AppleWorks. Use InWords to scan reports,
books, letters, and other documents. Requires a Quickie or
LightningScan GS scanner. (List Price: $129.95) $77.95 plus
$3.50 s/h.
Polaroid DataRescue Disks: The world’s only disks that
insure your data. Polaroid guarantees that it will try to re¬
cover all data you lose for any reason. Box of ten 5.25" disks:
$10.00. Box of ten 3.5" disks: $14.50. $3.50 s/h per order.
Mail to: National AppleWorks Users Group, Box 87453, Canton, Michigan 48187, (313) 454-1115.
Payment must accompany purchase orders. Prices are in U.S. Jiinds.
Foreign orders by credit card only, foreign postage additional Please specify air mail or surface delivery.
AW Handbook Vol. One
AW Handbook Vol. Two
The UltraMacros Primer
How to Get Started: DB
How to Get Started: SS
AW Wall Chart
AW Command Cards
Electronic Index Disk
Public Domain Catalog
Word Processor I Tape
Word Processor II Tape
Data Base Tape
Spreadsheet Tape
AppleWorks 3.0 Tape
Set of 5 Tapes
DeskTbols
Desklbols II
FileMaster
GS Font Editor
Graph
MacroEase
Outliner
PowerPack
QuickSpell
ReportWriter
SideSpread
SpreadTbols
SuperFonts
SuperFonts Activity
Guide
SuperForms
TeleComm
Thesaurus
TextTools
UltraMacros
Companion Plus
Point-to-Point
InWords
Polaroid 5.25" Disks
Polaroid 3.5" Disks
Subtotal $
Shipping $
Total $
□ Check
□ VISA/MC
□ P.O. No.
Credit Card #
Exp. Date
Signature
Phone Number
NAUG I.D. Number
Name
Address (No P.O. boxes, please)
a?
City
State
—Apple II Hard Disk Primer—i
The Apple II Hard Disk Primer tells you everything you need to know
to use a hard disk drive with your Apple II computer. The Primer teaches
you how to select, install, configure, and use a hard disk system with
AppleWorks, AppleWorks GS, desktop publishing programs, and all other
popular Apple II applications. The author describes the necessary proce¬
dures in a step-by-step fashion that is easy to read and understand.
I
Hard Dhk Drive
iUi WUeg
The chapters in this book describe:
♦ How to select a hard disk drive.
♦ How to connect a hard disk to your computer.
♦ How to configure your computer for a hard disk.
♦ How to install an operating system.
♦ How to organize the files on your drive.
♦ How to use hard disk management software.
♦ How to install AppleWorks and AppleWorks enhance¬
ments on a hard disk.
♦ How to install AppleWorks GS and other 16-bit
programs.
♦ How to back up and optimize your disk.
♦ How to solve common hard disk drive problems.
The 136-page Apple U Hard Disk Primer is fully indexed,
includes a foreword by Ruth Witkin, and costs $16.95
($14.95 for NAUG members) from the National AppleWorks
Users Group.
NAUG policy: Satisfaction guaranteed or your money back.
□ Please send me _ copies of the Apple II Hard Disk Primer.
□ I am a NAUG member. Enclosed is $14.95 plus $3.50 shipping for each book.
□ I am a non-member. Enclosed is $16.95 plus $3.50 shipping for each book.
Total Enclosed $_ □ Check □ Visa/MasterCard □ P.O.No.
Credit Card #
Expiration Date
Signature
Phone Number
Name (Please print)
NAUG I.D. Number
Address (UPS shipping - No PO. boxes please.)
City, State, Zip
The Apple U Hard Disk Primer is the perfect “how to” book for users who have just purchased a
hard disk drive, those thinking about upgrading their system, and hard disk owners who want to
get more from their computers. Chapters in the book compare the different types of hard drives and
take you through the step-by-step procedures necessary to install and configure your hard disk
drive. Other chapters describe how to use hard disk management programs, how to install Apple-
Works, AppleWorks GS, and other programs on the drive, and suggest ways to back up and optimize
your drive. The Apple n Hard Disk Primer is a valuable addition to your Apple II library.
Mail to: National AppleWorks Users Group, Box 87453, Canton, Michigan 48187, (313) 454-1115.
Payment must accompany purchase orders. Prices are in U.S. Jimds. Foreign orders by credit card only, postage additional. Specify surface or air.
This book gets you past
the awestruck stage to the
comfortable-as-old-shoes
stage in the shortest possible
time. It begins with things to
consider before buying a hard
disk, explains how to install it,
then describes how to work
with it on a daily basis.”
—Ruth Witkin, inCider Magazine
My Favorite Template
A Medical Insurance and Tax
Tracking Template
by Stan Hecker
H ealth insurance can be a mixed blessing.
Although it is a source of comfort, keeping
track of who has been paid for what service and by
whom is a challenge that can lead us to envy our
global neighbors who embrace national health¬
care plans.
This month’s template is an AppleWorks spread¬
sheet developed by William Richards of Bowie,
Maryland. Mr. Richards’ template accurately tracks
medical bills and payments, tracks the tax implica¬
tions of those payments, and even tracks the tax-
deductible driving expenses you incur while get¬
ting medical care.
Assumptions
The Medical Insurance Template makes the follow¬
ing assumptions:
1. The “primary insurer” covers a portion of each
bill. This could be an employer, the employer’s
insurer, Medicare, or another government pro¬
gram.
The primary insurer can either pay the provider
of medical care directly or reimburse the family
for payments they make.
2. The “secondary insurer” provides supplemental
coverage for all or a portion of the expenses not
covered by the primary insurer. This can be a
“Major Medical” policy paid by an employer
(which usually includes a deductible) or a
Medicare supplemental policy purchased by the
family.
The secondary insurer pays only the family; it
reimburses the family for payments made to
providers.
3. The provider will receive payment from either
the primary insurer, the family, or both, but
never from the secondary insurer.
The Template
Figure 1 presents the template you will develop.
Figure 1 also includes data from an imaginary cou¬
ple’s medical care and payments as of mid-May
1991.
Rows 4-9 show reimbursements received in 1991
for services provided in 1990. John and Jane paid
these bills and claimed their payments as medical
deductions against their 1990 income tax. Now they
must show those reimbursements as “Other Income”
in 1991. The total amount appears in cell AH11.
Rows 10-14 track medical expenses incurred in
1990 that are not paid until 1991.
The data in rows 7 and 13 indicate that John and
Jane paid 50% of the cost of John’s earache treat¬
ment in 1990. They correctly deducted this pay¬
ment and their mileage from their 1990 taxes.
However, the final payment, and all the insurance
reimbursement, occurred in 1991. Consequently,
the entry apportions the insurance payment
between the proper 1990 and 1991 tax deductions.
Start with a Vertical Line
The template in Figure 1 is for the 1991 tax year.
We will develop a template for 1992 but will enter
our 1991 end-of-year medical expenses that will
have an impact on our 1992 taxes.
Start by creating a separate spreadsheet called
“LINE” that contains a vertical line. [Ed: See the
article entitled “How to Add Vertical Lines to a
Spreadsheet” in the July 1990 issue of the Apple-
Works Forum.] Set the column width to one charac-
AppleWorks Forum
November 1991
Page 19
My Favorite Template...
Figure 1: Insurance Tracker
File: INSUR.91
Provider
=b==c==d=e=
|Service Data |
| From To |For
41 REPAYMENT OF 1990 DEDUCTIONS | |
5| I I
6|Matro Clinic (Cut Fingar) |12/10 |John
7|Family Doctor (Earache) |12/30 |John
8|Prescription Medicine |01/03 - 12/29|Jana
9|Prescription Medicine |01/03 - 12/29|John
101 -
111PAYMENTS FOR MEDICAL SERVICES RECEIVED IN 1990
12 |
13|Family Doctor (Earache) |12/30 |J
141-
151 PAYMENTS FOR MEDICAL SERVICES RECEIVED IN 1991
RECEIVED IN 1990
Med Travel |
Miles Pkg |
Amount
Billed
Balance—>
Pri Clm Sbmtdj
By Date |
Self 12/11/90
Self 01/02/91
Self 05/28/91
Self 05/29/91
Saif 01/02/91
Pri Ins
Paid
Jan 10
Jan 23
Sec Clm Sfcmtd
By Date
Saif 01/14/91
Saif 01/26/91
Saif 06/25/91
Saif 01/26/91
17|Family Doctor (Sore Throat)
101/11
|Jane|
3.3
| 65.00|Self 01/12/91|W/I Deduct| N/A |Self 02/22/91|
18|Family Doctor (Joint Pain)
101/17
|Jane|
3.3
| 82.00|Self 01/18/911
52.58|Feb 08|Self 02/08/911
191Metro Radiology (X-rays)
101/17
| Jane | ]
VA
| 180.00|Self 01/31/91|
135.00|Mar 11|Self 03/12/91|
20|Specialist (Heart Prob.)
102/06
|John|
59.0 1.7!
i| 231.001 Prov |
98.25|ToProv|Self 03/01/91|
21|Dentist (Exam & Cleaning)
102/08
|Johnj
7.2
| 90.00| (Uninsured) |
1 1 1
22jFamily Doctor (Joint Pain)
103/01
I Jane|
3.3
| 82.00 j Prov |
60.00|ToProv j Self 03/01/911
23|Therapist (Joint Pain)
103/03
|Janej
5.5
| 120.00|Prov |
1 1 1
241 Family Doctor (Exam 6 Pap)
104/10
|Jane|
3.3
| 103.001 Self 04/19/911
75.00|May 10|Self 05/10/91|
251 Metro Radiology (Mammogram)
104/23
|Janej
3.3
| 90.00|Prov |
60.00|ToProv|Self 06/01/91|
26|Metro Clinic (Brkn Finger)
105/01
|Johnj
4.6
| 138.001 Self 05/16/911
1 1 1
27 |Hosp Emerg Ren (Irr Heart)
105/04
jJohnj
12.4
| 200.00JProv |
150.00|ToProv|Self 06/01/91|
| 105.2 1.75| 1426.00|
ter and copy the vertical line down 32 cells. Then
copy the column containing the line to the clipboard.
Building the Template
The basic template consists of 14 columns for data,
three columns for formulas, and one column for
remarks. We will create the bottom of the template
first. Then we will modify rows 4-14 which give
the template much of its power. [Ed: A working
template appears on this month’s issue of NAUG
on Disk; $10, postpaid, directly from NAUGf
The Layout
1. Start by creating a new spreadsheet called
INSUR.TRACK. Save the template frequently
as you work.
2. Use the Apple-V command to set the calcula¬
tions to “Manual” and the Value Format to
“Fixed” with two decimal places.
3. As you can see from Figure 1, several narrow
columns contain only vertical lines. Follow
these steps to create those lines:
A. Copy the vertical line from the clipboard to
columns B, D, F, I, K, M, O, Q, S, U, W, Y,
AA, AC, AE, AG, and AI.
B. Use an Apple-L command to make these
columns one character wide.
4. Use an Apple-L command to set the column
widths as follows (remember that all columns
default to nine characters wide):
A. Narrow columns G, H, P, V, and AB to six
characters.
B. Widen columns J, N, T, X, AD, and AH to
10 characters.
C. Widen columns C, L, and R to 13 characters.
Page 20
November 1991
AppleWorks Forum
My Favorite Template...
-- V.
—— 1 —1 —————U-V —- — W—
Sac Ins | Data |
Paid | Dpst |
Paid by | Check | Date | Total Amt | Balance |
Self | Number | Paid |Paid Prov |Owed Prov|
Inc Tax |
Expense | Remarks
1 1
1 1
12.90|Fob 07|
10.00|Fab 22|
1 1
1 1
1 1
1 1
iii ii
lit ii
iii ii
iii ii
iii ii
iii ii
iii ii
"Othar" Inccna on 1991 Inccaa Tax Return —> |
i
i
-51.601
-40.00|Actual insurance payments $60.00 and $20.00
1
-15.491
1
107.091
10.00|Feb 22|
45.00|
1497
jFeb 01|
45.00|
i
5.00|Apportioned pymt. See sve date 12/30 above
i i
i i
W/I Daduc 1 N/A |
i
i
65.00|
Cash
i i
i i
|Jan 11|
i
i
65.001
i
i
i
i - --
i
i
65.001
W/I Daduc | N/A |
82.00|
1530
|Jan 17|
82.00J
i
29.421
45.00|Mar 26|
180.00J
1551
|Feb 01|
180.00|
i
1
32.75|Mar 20|
132.75|
1597
|Mar 07|
231.00|
i
100.001
1 1
90.00|SoaRmrks| |
90.00|
i
90.001$50.00, 02/08; $40.00, 03/07
20.00|Apr 17|
22.00|
i i
82.00|
i
2.001
1 1
i
i i
i
120.001
1
25.00|May 23|
103.00|
1638
(Apr 10|
103.001
i
3.00|
20.00| Jun 221
90.00|
1653
|Apr 231
150.00|
-60.00|
70.00|
1 1
138.00|
Visa
|May 01|
138.001
i
138.001
50.00|Jun 18|
1 1
1 1
1 1
1 1
1 1
i
i
i
i
i
i
1 1
1 1
1 1
1 1
1 1
1 1
150.001
1
1
1
1
1
50.00|
1
1
1
1
1
-50.001
1
1
1
1
1
202.751 |
i
1 1
1316.00|
110.001
452.421
D. Narrow column Z to eight characters.
E. Widen column A to 27 characters.
F. Make column E wide enough to accommo¬
date the longest first name in your family.
G. Widen column AJ to 30 characters.
5. Enter the heading into rows 1-3 by typing the
labels and hyphens that are in the first 3 rows of
Figure 1. (Remember to type a quotation mark
before entering a hyphen.)
6. Put the cursor in cell Al, issue an Apple-L
command, and format the first two rows so
AppleWorks centers all labels.
7. Enter one blank space in cell Z4. (You will need
to use the quote key before pressing the Space
Bar and the Return Key.) That defines the cell
as a “label”. Use Apple-C to copy the blank
space down column Z through cell Z32.
The Formulas
8. AppleWorks 3.0 users should go to cell AD4
and type the formula @if(P 4="ToProv",N4+x4,x4).
Use Apple-C to copy the formula down column
AD through cell AD32. Make all cell references
“Relative”.
This formula computes the total payments made
to the provider by the primary insurer and the
family.
AppleWorks 1.x or 2.x users should type the
formula @IF(P4=1,N4+X4,X4) in cell AD4. When
using the template, they should enter a “1” in
column P to indicate that the primary insurer
paid the provider.
9. Enter the formula @if (J4-ad4=0, J4-AD4) into
cell AF4. (AppleWorks 1.x and 2.x users should
enter the formula +J4-AD4.) Use Apple-C to copy
AppleWorks Forum
November 1991
Page 21
My Favorite Template...
the formula down column AF through cell
AF32; make all references “Relative”.
These cells compute the difference between the
total amount billed and paid.
Sometimes an insurer will send money to the
provider even when the claim shows that the
family paid the bill. When this happens, a nega¬
tive amount will appear in column AF.
10. Go to cell AH4 and type the formula
@IF (AD4- (N4+T4)<>0,AD4- (N4+T4) , . (AppleWorks
l.x and 2.x users should enter the formula
GIF (AD4- (N4+T4) <>0, AD4- (N4+T4) ,0) .) Use Apple-
C to copy the formula down column AH
through cell AH32. Make all cell references
“Relative”.
This column shows the unreimbursed medical
expenses paid by the family. You will use this
data to determine the family’s medical income
tax deduction.
Tracking Last Year’s Transactions
Much of the power of this template lies in its ability
to track last year’s tax deductions that were reim¬
bursed in the current year. This year you must treat
these reimbursements as income for tax purposes.
Now you will develop the segment of the template
that tracks these expenses.
Follow these steps:
11. Use an Apple-C command to copy the line of
hyphens in row 3 to the clipboard. Then copy
the line from the clipboard into rows 14 and 33.
12. Use an Apple-B command to blank the cells in
row 12 and the block of cells in XI1 through
AF11.
13. Put the cursor in cell A10, enter a quotation
mark, and use the hyphen key to draw a line
across the cell. Then copy cell A10 into cells
B10-L10.
14. Use the hyphen key to type a line in cells N12-
AJ12.
15. Type the label “REPAYMENT OF 1991
DEDUCTIONS” in cells A4-B4.
16. Type the label “PAYMENTS FOR MEDICAL
SERVICES RECEIVED IN 1991” in cells All-
Ell.
17. Type the label “‘Other’ Income on 1992 Income
Tax Return —>” in cells X11-AF11. (Press the
quotation key twice to enter a quotation mark at
the beginning of this label.)
18. Type the label “PAYMENTS FOR MEDICAL
SERVICES RECEIVED IN 1992” in cells A15-
E15.
19. Type the label “Balance—>” in cells G13-H13.
J13 will contain the unpaid balance for services
performed in 1991.
20. Issue an Apple-L command and format all val¬
ues in the block of cells between G6 and G34 as
Fixed with one decimal place.
21. Go to cell AH 11 and enter the formula
@ABS(@SUM(AH5...AH10)).
Calculating the Totals
Now you will enter the formulas that compute the
totals at the bottom of the template. Follow these
steps:
22. Enter the formula @sum(gi6. . .G33) in cell G34.
23. Copy the formula in cell G34 into cell H34.
Make all references “Relative”.
24. Enter the formula @sum(ji3. .. J33) into cell J34.
25. Copy the formula in cell J34 to the clipboard as
a “block” and copy it from the clipboard as
“Formulas and Values” to the end of columns
N, T, AD, AF, and AH. Note that AppleWorks
automatically makes all cell references “Rela¬
tive” when it copies from the clipboard.
Your template should now look like the example in
Figure 1 without the sample data.
Protect Your Work
Now you will protect your work so you do not
accidentally over-write the formulas or labels. [Ed.
See the article entitled “How to Change the Apple-
Works Spreadsheet Defaults” in the September
1990 issue of the AppleWorks Forum for step-by-
step directions that describe how to use Apple-
Works’ Protection Command.] Follow these steps:
Page 22
November 1991
AppleWorks Forum
My Favorite Template...
26. Put the cursor in cell Al, issue an Apple-L com¬
mand, select “Block”, and use the Apple-9 and
Apple-. (Apple-period) keys to highlight the
entire spreadsheet. Then protect the entire
spreadsheet so nothing can be entered anywhere.
27. Use the Apple-L command to allow “Anything”
in cells G17-G32, N6-N9, N13, N17-N32, T6-
T9, T13, T17-T32, Z13, Z17-Z32, AJ6-AJ9,
AJ13, and AJ17-AJ32.
28. Use the Apple-L command to allow “Labels
Only” in cells A6-A9, A13, A17-A32, C6-C9,
C13, C17-C32, E6-E9, E13, E17-E32, L6-L9,
L13, L17-L32, P6-P9, P13, P17-P32, R6-R9,
R13, R17-R32, V6-V9, V13, V17-V32, AB13,
and AB17-AB32.
29. Use the Apple-L command to allow “Values
Only” in cells H17-H32, J13, J17-J32, X13, and
X17-X32. (AppleWorks 1.x and 2.x users
should set protection to allow “Values Only” in
cells P6-P9, P13, and P17-P32.)
30. Use the Apple-L command to center all labels
entered into cells Z6-Z9, Z13, and Z17-Z32.
31. Save the template to disk and lock it if you
wish. [Ed: See the article entitled “How to
Lock Your Templates” in the May 1990 issue of
the AppleWorks Forum for step-by-step direc¬
tions that describe how to lock your templates.]
Using the Template
I suggest that you start using the template immedi¬
ately; your end-of-year medical services are more
likely to impact two tax years and are thus more
complex than other transactions.
Start by renaming the template INSUR.92 so you
keep your health insurance transactions for each
tax year in a separate file.
The most convenient way to use the template is to
enter the transactions in chronological order when
you receive a medical service. Then columns A-J
can serve as a “diary” of medical events and
expenses. Columns L-V track the progress of insur¬
ance claims. Columns X-AH help you track the
financial data and tax implications. Use the sample
data in Figure 1 to help you record your medical
transactions.
Remember that recalculation is set to “Manual”;
you must issue an Apple-K before you can trust the
results on the screen. Also remember that you must
enter a quotation mark before you enter a date
expressed as a number (e.g., “12/10” that repre¬
sents December 10th in cell C6).
Your circumstances might dictate expanding any of
the three main sections of this template. You can
use the Apple-C command to insert copies of row 9
between rows 9 and 10, copies of row 13 between
rows 13 and 14, and copies of row 32 between
rows 32 and 33.
With two exceptions, this template makes review¬
ing and tracking your medical expenses straightfor¬
ward. The exceptions:
A. A negative number in column AF indicates that
the provider of medical care has been paid by
both an insurer and the family. That provider
owes you a refund or credit.
B. A negative number in column AH indicates that
you received payments from the insurers which
you have not yet paid to the provider.
Conclusion
Although some accounting spreadsheets and pack¬
ages can handle medical records, this month’s
template provides at-a-glance details of all medi¬
cal insurance transactions.
The template assures that you are not losing money
rightfully owed you, and will help you explain
your position to insurance company functionaries
and Federal tax auditors.
[Stan Hecker is on the administrative staff at
Michigan State University, East Lansing, Michi¬
gan, and is a partner in H&H Consulting, a Michi¬
gan concern specializing in school district finan¬
cial and population analyses. William Richards, a
retired naval aviator, has a background in real
estate and presently does volunteer tax accounting
for the elderly.]
AppleWorks Forum
November 1991
Page 23
ini
Improved software and hardware for
the best-selling Apple II hard drive!
Order today!
To place an order or for more
information, see your dealer or
call (214) 241-6060 today, 8:30AM
to 6:30PM (CST), M-F. Or send
check or money order to Applied
Engineering. MasterCard, VISA
and C.O.D. welcome. Texas
residents add applicable sales tax.
Vulcan Gold 40Mb.$899
Vulcan Gold 100Mb.$1795
Gold-Cache Software Upgrade... $59
The Vulcan Lives in
New Vulcan Gold.
Tested and proven for years
with all existing peripherals.
Support for years to come.
Now Vulcan, the premier hard
drive for the Apple II family, gives
you more speed and flexibility than
any external or internal drive with
the new and improved version—
Vulcan Gold. Look at these features!
• Designed specifically for the
Apple II series.
• Preformatted—plug it in and
you’re off!
• Recognizes ALL Apple
software including GS/OS,
ProDOS, DOS 3.3, Apple
Pascal, CP/M and MS-DOS
for the PC Transporter.
• Can be split in up to 16
different partitions.
• 70 watt power supply
(nearly twice the capacity of
competing systems).
• Super-fast, state-of-the-art,
IDE caching drive.
New Life for
Existing Vulcans*
Existing Vulcan GS owners can
now upgrade to the Gold-Cache
software at a super-low price.
Your Vulcan will be as good as
gold.
• 300-900% increase in
writing speed!
• 50% increase in reading speed.
• Quickly choose which
partition and even which
drive to boot from immedi¬
ately upon startup—simply
hold down the space bar
and select.
Applied Engineering
The enhancement experts.
A Division of AE Research Corporation
P.O.Box 5100 TO t nrn
Carrollton, TX 75011 USA
© 1991■ AE Research, Inc. All rights reserved. Brand and product
names are registered trademarks of their respective holders.
Prices and specifications subject to change without notice.
Vulcan GS 40 & 100Mb only. 20Mb
and Vulcan He, call AE sales
for upgrade details.
Apple Works News
News and Special Offers for
NAUG Members
NAUG
NAUG announced that it will develop and distribute
the 1991 versions of 1040Works, a set of profession¬
al Apple Works spreadsheet templates that prepare
your Federal Income Tax returns. The templates
help you collect and enter data, do all the necessary
computations, and print the required tax forms.
1040Works is easy to use and includes complete
documentation in a clearly written 64-page manual.
The 1991 version of 1040Works will prepare 24
forms (new this year are forms 2210, 8283, and
supplemental schedules for Schedules E and F).
The 1991 package will also offer enhanced linkage
of data between forms and will include menus that
help you navigate between forms. The 1991 ver¬
sion will also let you print on plain white paper
instead of on the green bar paper required earlier.
1040Works lists for $32.95 plus $3.50 s/h; NAUG
members can get 1040Works for $29.95 plus
$3.50 s/h. Owners of earlier versions of
1040Works can update to the 1991 templates for
$22.95 plus $3.50 s/h.
NAUG also announced that it will distribute the
1040Works Tax Planner, a comprehensive new tax
planning package for AppleWorks. The 1040Works
Tax Planner estimates your Federal Income Tax for
1992-1994, determines whether you will be affect¬
ed by the Alternative Minimum Tax, calculates
your correct withholding, calculates your quarterly
tax payments, and compares alternative financial
strategies to legally minimize your federal tax lia¬
bilities. The 1040Works Tax Planner can help time
your investment decisions to maximize your after¬
tax yields.
1040Works Tax Planner lists for $29.95; NAUG
members can buy the Tax Planner for $26.95 plus
$3.50 s/h. The Tax Planner costs $19.95, including
shipping, if ordered with 1040Works or with a
1040Works update.
NAUG will ship 1040Works and the 1040Works
Tax Planner by the end of January 1992. Owners of
earlier versions will receive update information and
special order forms this December. New 1040-
Works buyers should wait for the order form and
NAUG discount offer that will appear in the Jan¬
uary 1992 issue of the AppleWorks Forum.
[National AppleWorks Users Group, Box 87453,
Canton, Michigan 48187; (313) 454-1115.]
ActaSoft
ActaSoft recently announced the availability of for¬
eign language versions of the company’s popular
Apple Works-based AlphaCheck Plus home and
small business accounting system. Foreign lan¬
guage versions require customization which costs an
additional $15; contact the company for further
information. (According to ActaSoft, British users
can customize their copy of AlphaCheck Plus by
changing the name of the “$” category to “£” and
the “Dollars” category to “Pounds”.)
NAUG members can buy AlphaCheck Plus direct¬
ly from ActaSoft for $39.95 plus $3.50 s/h. [Acta¬
Soft, 19700 Wells Drive, Woodland Hills, Califor¬
nia 91364; (818) 996-6731.]
America Online
America Online recently reorganized its Apple-
Works area which is now a part of the Apple Pro¬
ductivity Forum. To access the NAUG area, use
the Apple-K command to issue the keyword
“APR” or “AW”, select “Direct Connect”, select
“Direct Connect Companies A to Se” and then
select “National AppleWorks Users Group”.
The NAUG area now contains more than 120 Pub¬
lic Domain files available for downloading. Joe
Connelly (“NAUG JoeC” on America Online), who
coordinates the NAUG area, uploads new files in
response to member requests.
AppleWorks Forum
November 1991
Page 25
Apple Works News
NAUG members use the NAUG area to post
Apple Works questions and answers and share ideas.
Until November 30, America Online offers one free
hour of America Online service to every NAUG
member who makes two or more posts that refer to
articles in this issue of the AppleWorks Forum. Our
thanks to Marty Knight (AFL Marty) for arranging
this special America Online offer for our members.
Apple Computer
Apple Computer announced that it will soon
release a series of new Apple II products including
GS/OS 6.0, a SuperDrive for enhanced Apple He
and IIgs computers, a new version of HyperCard
IIgs, and a second edition of the Apple II Guide.
GS/OS 6.0 will be easier to install than earlier ver¬
sions of GS/OS, will include an improved Finder,
and will give Apple IIgs developers more control
over multimedia devices such as laser disks and
CD-ROMs. Version 6.0 will also include new Con¬
trol Panels, CDAs (Classic Desk Accessories), and
NDAs (New Desk Accessories).
GS/OS 6.0 represents a significant upgrade of the
Apple IIgs operating system, and NAUG will pub¬
lish a more complete description of this product
when it is ready for release by Apple. NAUG
members will be able to get the new version of
GS/OS from NAUG’s Public Domain Library; we
will announce price and availability in a future
issue of the AppleWorks Forum.
Apple’s new SuperDrive will let Apple II users
store up to 1.44 megabytes of data on a high densi¬
ty disk. These drives will also let users read and
write Macintosh and MS-DOS disks.
The new version of HyperCard IIgs will be faster
and support more HyperTalk commands than the
current version of the program. The new Hyper¬
Card will also offer a Media Control Stack that
gives users enhanced control over multimedia
peripheral devices.
Apple did not announce release dates for these new
products, but we expect the new version of GS/OS
to be available during the first quarter of 1992. The
other products should be available before the end
of the current school year. Look for additional
information about these products in future issues of
the. AppleWorks Forum. [Apple Computer, 20525
Mariani Avenue, Cupertino, California 95014;
(408) 996-1010.]
Claris Corporation
Claris Corporation’s Technical Support group
recently established a Fax Answerline that can fax
Claris technical notes to your fax machine. You call
the Answerline and order a fax copy of the catalog.
Then you call and order up to five technical notes.
The Answerline can transmit answers to the 42
most frequently asked questions about AppleWorks
and AppleWorks GS. [Ed: These notes are among
the 200+ technical notes on the Claris Technical
Notes Disk that Claris released to NAUG. See the
Public Domain Update article elsewhere in this
issue for information about this disk.]
To use the Claris Fax Answerline, call (800) 800-
8954 with a touch tone phone.
Claris also offers a Voice Answerline which uses
the technical notes to provide recorded answers to
common questions. To use this service, call (800)
735-7393 with a touch tone phone. [Claris Corpo¬
ration, 5201 Patrick Henry Drive, Box 58168,
Santa Clara, California 95052; (408) 987-8227.]
Computer Literacy Press
Computer Literacy Press (CLP) publishes
Luehrmann and Peckham’s Hands-On AppleWorks,
which CLP reports is the most popular instruction¬
al package for AppleWorks classes.
NAUG members can now get a 30-day free exami¬
nation copy of Hands-On AppleWorks 3. This
includes a new edition of the Luehrmann and Peck-
ham workbook and a teacher’s manual that covers
AppleWorks 3.0.
The student textbook costs $21.95 (hardcover:
$26.95), blackline masters for quiz sheets and
overhead transparencies cost $32.95, and a large
wall chart of AppleWorks 3.0 commands costs
$14.95. A copyable template disk (list price:
$14.95) and a teacher’s guide (list price: $14.95)
are free with each 25 books you order. [Computer
Literacy Press, 5750H Obata Way, Box 22383,
Gilroy, California 95021-2383; (800) 225-5413.
Fax: (408) 848-1483.]
Page 26
November 1991
AppleWorks Forum
AppleWorks News
Diskovery Educational Systems
NAUG members who are educators should order the
catalog just released by Diskovery Educational Sys¬
tems. (Diskovery, which specializes in selling Apple
n, Macintosh, and MS-DOS software to the educa¬
tional community, encourages software developers to
release products to educators at special prices.)
Diskovery’s discounts vary widely depending on the
product and platform, with large discounts available
for some expensive Macintosh and MS-DOS prod¬
ucts. [Diskovery Educational Systems, 1860 Old
Okeechobee Road, Suite 105, West Palm Beach,
Florida 33409; (800) 331-5489, (407) 683-8410.]
GSTape Backup System
GSTape is an Apple lies tape backup program that
runs under GS/OS and backs up hard disk drives
onto most popular SCSI tape backup systems.
GSTape lets you select file by file operation, incre¬
mental or complete backups, multiple volumes per
backup, multiple backups per tape, and multiple
tapes per backup. GSTape requires a Rev. C or later
Apple SCSI card and supports most popular SCSI
tape systems.
GSTape normally costs $35. Until January 30,
1992, NAUG members can get GSTape and com¬
plete documentation directly from the developer
for $25. Send a check or money order and your
NAUG membership number with your order. (The
developer does not accept credit cards or COD
orders.) [Tim Grams, Box 462283, Garland, Texas
75046; (214) 495-7675.]
JEM Software
By the time you read this, JEM Software will be
shipping version 2.0 of Double Data, Dan Verkade’s
AppleWorks enhancement that lets you include up
to 60 categories in any AppleWorks data base.
Double Data 2.0 seamlessly integrates all 60 cate¬
gories into a single record. This lets you scroll
through all the categories in multiple record or sin¬
gle record layout and print all the categories in a
tables format or labels format report.
Double Data 2.0 includes a utility program that
lets you print all 60 categories in a single column
(AppleWorks’ labels format report limits you to a
maximum of 15 lines) and a utility that lets you
lock a report format so users can print the report
but not change its format.
Double Data 2.0 lists for $40. Until January 1,
1992, NAUG members can buy Double Data
directly from JEM for $35 plus $3 s/h. Include
your NAUG membership number with your order.
Upgrades from earlier versions of Double Data
cost $10 plus $3 s/h; include your original Double
Data disk or proof of purchase with your upgrade
order. JEM Software accepts Visa and MasterCard.
[JEM Software, 7578 Lamar Court, Arvada, Col¬
orado 80003. Orders only: (303) 422-4856.]
Marin MacroWorks
Marin MacroWorks announced the release of Ultra-
AWesome Macros II, 200K of useful macro-powered
utilities by Will Nelken. The UltraAWesome II disk
includes Auto-Hyphen (hyphenates AppleWorks
word processor documents), QuickMath (an
onscreen calculator), Order Manager (prepares
invoices and mailing labels), Converter (converts
numbers between the hexadecimal and decimal num¬
ber systems), Answer Sheet Maker (creates blank
answer sheets). Word and Letter Counter (counts the
number of one-letter, two-letter, three-letter, and larg¬
er words in a document). Font Commander (a com¬
panion to PickFonts for SuperFonts users), Calendar
Max (adds four functions to the TimeOut Calendar),
SS Word Wrap (adds word wrap to the spreadsheet)
and more than a dozen other useful macros.
UltraAWesome Macros II normally costs $19.95.
Until December 25, NAUG members can get
UltraAWesome Macros II directly from the pub¬
lisher for $17.50 plus $2.50 s/h or UltraAWesome
Macros I and II for $32.00 plus $3.00 s/h. (See the
November 1990 issue of the AppleWorks Forum
for a complete description of the UltraAWesome I
disk.) Include your NAUG membership number
and indicate whether you want 3.5 or 5.25-inch
disk copies of the program when you order.
[Marin MacroWorks, 1675 Grand Avenue, San
Rafael, California 94901.]
Stone Edge Technologies
DB Master Professional is a powerful, full-fea¬
tured, relational data base management program
AppleWorks Forum
November 1991
Page 27
Apple Works News...
that brings most of the capabilities of stand-alone
MS-DOS data base programs to the Apple 13. DB
Master Professional offers password file protec¬
tion, data validation, calculated fields, lookup
fields, import and export files, and complete
reporting capabilities. The program is far more
powerful but more difficult to learn than the Apple-
Works data base module. We recommend DB Mas¬
ter for members whose data base needs exceed the
capabilities of Apple Works.
DB Master Professional originally cost $295. How¬
ever, Stone Edge Technologies is selling their
remaining stock of the program for $100 (plus $5
s/h) including both 5.25-inch and 3.5-inch disks
and a well-written 600+ page manual and reference
guide. [Stone Edge Technologies, Box 3200, Maple
Glen, Pennsylvania 19002; (215) 641-1825.]
TimeOut-Central
TimeOut-Central is 3.5-inch disk magazine filled
with macros, tips, columns, and programs for
AppleWorks 3.0 and TimeOut users. Randy
Brandt, the editor of TimeOut-Central, is respected
in the AppleWorks community as one the develop¬
ers of AppleWorks 3.0, as the author of TimeOut
UltraMacros, Outliner, and many other Apple-
Works enhancements, and as the owner of JEM
Software, one of the major developers of Apple-
Works enhancements.
Through December 31, NAUG members who order
a one-year TimeOut-Central subscription will
receive the May and July issues of TimeOut Central
free. The May disk includes Mr. Brandt’s “Macros-
ToMenus”, a TimeOut application that converts a
macro set into a TimeOut application you can
launch by pressing <oa-Escape>. The July disk
includes “MouseText” (a TimeOut application that
lets you type mousetext characters directly into the
Word Processor), and an OA-H init (which lets you
“print” the screen to the printer, to the clipboard as
printable text, or to the clipboard with mousetext).
A 6-issue (one year) subscription to TimeOut-Cen¬
tral costs $42. Ask for the “NAUG Offer” and
include your NAUG membership number to get
the free disks with your order. [Resource-Central,
Box 11250, Overland Park, Kansas 66207; (913)
469-6502. Fax: (913) 469-6507.]
Introducing the brand new Pegasus™ internal
hard drive for your Apple Ilgs.®
Simply...
0 FASTER
a SCSI
0 POWERFUL
0 UNIQUE
0 RELIABLE
0 STATE OF THE ART
Why settle for a plain vanilla hard drive? Only Pegasus
from Econ Technologies gives you what you really want:
a faster, quieter, more reliable, SCSI, internal hard drive
designed specifically for the Apple Ilgs... 50, 100 and 200
megabyte capacities... complete drive management and
backup software that fully exploits GSOS... unbeatable
warranty with a money back satisfaction guarantee... all at
a price unheard of for an internal drive!
So when you’re ready to expand your mass storage, think
about the hard drive designed by Apple II users for Apple II
users. Then call or write us for a free brochure that will help
you choose the hard drive that is right for your needs.
Special Prices For NAUG Members!
ECON Technologies, Inc.
P.O. Box 195356
Winter Springs, FL 32719
(407) 365-4209
America Online: ECON
"Internal Hard Drive Solutions"
Apple Ilgs is a registered trademark of Apple Computer, Inc.
Page 28
November 1991
AppleWorks Forum
Data Base Tip
Three Commands That Can
Improve Your Labels
by Ann Bennett
A ppleWorks’ ability to print labels format
reports adds important flexibility to the data
base module. You can use the labels format report
to print labels or fill in forms. You can even use
labels format reports to print checks if you do
your bookkeeping with the AppleWorks data base
module.
This article describes three commands that add
power to the labels format report. These com¬
mands work when you are defining the format for
a label on the screen. I will use the sample label
formats in Figure 1 for all the examples.
Apple-J
The Apple-J command tells AppleWorks to “left
justify” the current category. You “left justify” a
category by getting a labels report format on the
screen, putting the cursor on the first letter of the
category name, and issuing an Apple-J command.
AppleWorks puts a “<” mark in front of the cate¬
gory name to indicate that this category is justified.
Figure IB displays a label format with the Last
Name, State, and Zip categories justified.
When you print this label, AppleWorks will print
the first name, leave one blank space, then print the
last name. If the person has a short first name,
AppleWorks will move the last name to the left. If
the person has a long first name, AppleWorks will
move the last name to the right.
Similarly, AppleWorks will adjust the placement
of the state and Zip Code information. The last
line will print with the name of the city, one blank
space, the state, another blank space, and then the
Zip Code. The program will adjust the location of
the state and Zip Code information so it accom¬
modates different length city and state names.
Note the following suggestions when using the
Apple-J command:
1. Do not use Apple-J to justify the first category
on a line.
2. Do not type the “< ” symbol. When you issue
the Apple-J command, AppleWorks inserts that
symbol on the screen to remind you that the cat¬
egory is left justified.
3. To cancel left justification, put the cursor on the
“<” symbol in front of the category name and
issue another Apple-J.
4. You must issue an Apple-J command for each
category you want to left justify. You do not gen¬
erally want to justify all categories in the label.
5. If you delete the first category on a line, Apple-
Works removes the Justify Command from all
remaining categories on the line. Re-insert
those commands as necessary.
Apple-V
There are times when you want to print one or
more category names in addition to the data itself.
For example, if you print labels for a drug store,
you might want the words “Expiration Date” to
appear on every label.
To print the category name, get the labels format
report on the screen, put the cursor on the first letter
of the category name, and issue an Apple-V com¬
mand. AppleWorks will display a colon and some
sample data after the category name to indicate that
the category was Apple-V’d. Figure 1C shows the
sample label that appears on the screen after you
Apple-V the City category.
Some general guidelines for the Apple-V command:
AppleWorks Forum
November 1991
Page 29
DataBase Tip
Label Format Report
Output
A
Basic labels format report
First Name
Last
Name
Henry James
(Apple-L)
Addressl
123 Main Street
Address2
Apt 12
City
State
Zip
Traverse CiMI
99999
B
Print data left-justified
First Name
<Last
Name
Henry James
(Apple-J)
Addressl
123 Main Street
Address2
Apt 12
City
<State
<Zip
Traverse City MI
99999
C Display category name
First Name
<Last
Name
Henry James
with data
Addressl
123 Main Street
(Apple-V)
Address2
Apt 12
City: Traverse City
<State <Zip
City: Traverse City MI
99999
D
Display heading in label
To the parents of:
Henry CLast Name
To the parents of
:: Henry James
next to data
Addressl
123 Main Street
(Apple-V, Apple-N)
Address2
Apt 12
City
<State
<Zip
Traverse City MI
99999
E
Print standard text not
First Name
CLast
Name
Henry James
related to data
Addressl
123 Main Street
(Apple-V, Apple-N)
Address2
Apt 12
City
<State
<Zip
Traverse City MI
99999
DO NOT BEND :
DO
NOT BEND:
1. Do not type a colon on the label format; enter
an Apple-V and AppleWorks will insert the
colon. That colon will also appear after the cat¬
egory name on the printed label.
2. An Apple-V’d category takes more room to
print because AppleWorks prints both the cate¬
gory name and the data. Make certain you
either left justify all remaining categories on the
same line or leave enough room to print both
the data and the category name.
3. You cancel the Apple-V command by putting
the cursor on the first letter of the category
name and issuing another Apple-V command.
4. You must issue an Apple-V command for each
category name you want to print. There is no
command that automatically prints all category
names.
Ideas For Using Apple-V
You can use the Apple-V command to print text
anywhere on a label. For example, imagine you
have a data base file of children in a school. You
want to print labels to the parents of the children,
not to the children themselves. That is, you want
every label to start with “To the parents of: ”.
The trick is to use the Apple-N command to tem¬
porarily change the name of the First Name cate¬
gory to “To the parents of ”. That gives you a cate¬
gory called “To the parents of ”, but the category
actually contains the first name of each child in
the school.
Then go to the labels format report and issue an
Apple-V for that category. The labels format will
look like the example in Figure ID. Now the
words “To the parents of ” will print before each
child’s first name when you print the labels. (Note
the word “Henry” after the category name in Fig¬
ure ID. AppleWorks automatically displays data
from the first record when you use the Apple-V
command to display a category name.)
You can also use this technique to print text any¬
where on the label. For example, imagine that you
want the text “DO NOT BEND” to appear in the
Page 30
November 1991
AppleWorks Forum
Data Base Tip...
lower right hand comer of every label. Either cre¬
ate a new category or rename an existing category.
Call the new category “DO NOT BEND”. Make
certain there is no data in this category.
Develop a label format report and put the DO NOT
BEND category in the lower right-hand comer, as
in Figure IE.
Put the cursor on the first letter in the category name
and issue an Apple-V command. A colon will appear
at the end of the category name. When you print the
report, “DO NOT BEND:” will print on each label.
There is no easy way to eliminate the colon after
the label. If it bothers you, consider making the
colon part of a design; name the category “:::DO
NOT BEND::” instead of “DO NOT BEND”. By
specifying a category name with three colons at the
beginning and two colons at the end, AppleWorks
will print a symmetrical pattern with three colons
before and three colons after the category name.
Apple-Z
The Apple-Z command lets you view a sample
label on the screen. Issue an Apple-Z anytime you
are developing a labels format report and Apple-
Works will replace the category names with sample
data from a label. You can look at the label and
determine if it follows the format you desire. If not,
issue another Apple-Z command to return to the
category names and move the categories around
again. The Apple-Z command then lets you look at
your new work. Unlike the Apple-J and Apple-V
commands, the Apple-Z command does not change
your printed output; it is a “toggle ” that lets you
see your work prior to printing the labels.
Conclusion
The Apple-J, Apple-V, and Apple-Z commands
add power to AppleWorks’ labels format report.
They’re simple, useful tools that help you produce
more attractive labels.
[Ann Bennett teaches AppleWorks and desktop
publishing at Winter Park Adult Vocational School
in Winter Park, Florida.]
how far
you can go and
how much you can do
with AppleWorks for Educators:
A Beginning and Intermediate Work¬
book. Incorporating clear, detailed,
and well-paced instructions, this
workbook has been written specifi¬
cally for educators with limited
computing experience. With her own
special brand of humor, Linda Rathje
guides you step-by-step through the
AppleWorks word processor, database,
and spreadsheet. Her extensive intro¬
duction to these major applications
will quickly build your skills and
confidence in practical computer use.
Price: $26.95 (member price $24.25)
plus $4.50 shipping. Canadian orders
add 7% GST (Registration #128828431)
AppleWorks for Educators
It's thorough, effective,
and best of all, it's fun!
To order AppleWorks for Educators contact:
ISTE, 1787 Agate St., Eugene, OR 97403-1923;
ph. 503/346-4414
Software requirements; AppleWorks 3.0
Book prices and shipping charges are subject to change
without notice. Any discrepancy in an order will be billed
or credited to customer.
AppleWorks Forum
November 1991
Page 31
Public Domain Update
New Disks in the NAUG Library
Change-A-File/Resurrection
Dr. Harold Portnoy continues to enhance Change-
A-File and Resurrection, two valuable utility pro¬
grams for AppleWorks. Change-A-File recovers
damaged files and makes AppleWorks 3.0 files
compatible with earlier versions of AppleWorks.
Resurrection recovers files on disks with damaged
directories. Complete descriptions of Change-A-
File and Resurrection appear on page 32 of the
September 1990 issue of the AppleWorks Forum.
NAUG updates its master Change-A-File/Resurrec-
tion Disk each time Dr. Portnoy releases a new ver¬
sion. At press time, the group was shipping Change-
A-File 4.06 and Resurrection 2.6. Change-A-File
4.06 includes numerous enhancements over earlier
versions of the program. For example, version 4.06
adds an enhanced user interface that lets you “page”
through a file that you view.
Change-A-File/Resurrection is shareware; after
receiving the program you send the author $8 for
the password necessary to use all the functions on
the disk. Dr. Portnoy requests only one shareware
fee per user, if you own an earlier version of
Change-A-File/Resurrection, you can order the
current disk from NAUG and use the earlier pass¬
word with the new disk.
Claris Tech Notes
The Claris Tech Notes Disk is a collection of more
than 200 AppleWorks word processor files contain¬
ing notes about AppleWorks and AppleWorks GS.
These files, which were developed by the Techni¬
cal Support staff at Claris Corporation, represent an
exceptional collection of ideas, suggestions, and
work-arounds to help you get more from Apple-
Works. NAUG converted these files into Apple-
Works word processor documents from their origi¬
nal text (ASCII) format.
Our thanks to Claris for releasing this information
to NAUG. These disks represent a significant con¬
tribution to the AppleWorks literature.
Claris Tech Notes comes on one 3.5-inch disk ($6)
or two 5.25-inch disks ($8), plus $2 s/h per order.
Just Add Water
Just Add Water is a collection of templates and
files that can help you form and manage a comput¬
er user group or club. The disk includes a sample
membership application, articles of incorporation,
a list of suggested meeting topics, a user group
budget template, bylaws, a data base template to
keep track of the disks in the group’s public
domain library, and clipart of Apple II computers
and accessories stored in APF format.
We recommend this disk for user group leaders and
organizers of computer clubs and computer camps.
Our thanks to the User Group Connection at Apple
Computer for compiling this excellent resource
disk and sharing this work with NAUG.
Mind Teasers
The NAUG Public Domain Library now includes a
revised version of Mind Teasers, Richard Reid’s
popular disk filled with brain teasers, puzzles, and
questions. You can use these files to test your men¬
tal agility or to enliven quizzes you give to others.
Our thanks to Mitchell Bernstein for updating this
disk for NAUG.
Petty Payroll Templates
Small business owners should consider the Petty
Payroll Templates, a collection of AppleWorks
spreadsheet templates developed by Gary Gibson
of Carlisle, Pennsylvania. These templates support
monthly, twice-monthly, or weekly pay periods,
accommodate up to three different pay rates per
employee, do all tax accounting, and support all
standard deductions (including IRAs, 401ks, Cred¬
it Union, insurance, union dues, and savings
bonds) and two user-defined deductions. Complete
documentation appears in a word processor file on
the disk.
Page 32
November 1991
AppleWorks Forum
Public Domain Update .. .
The templates include the formulas necessary to
calculate the Pennsylvania State Income Tax and a
local 1% income tax. You can customize the tem¬
plates for your own needs or have the template
developer do the customization for $25.
The templates require AppleWorks 2.0 or later and
require at least a 56K AppleWorks desktop.
The Petty Payroll Templates are shareware. You
send the author $10 if you use the templates on this
disk.
TimeOut Pseudodisk
The NAUG Public Domain Library now contains
TimeOut Pseudodisk, which significantly reduces
the need for disk swapping when you boot Time-
Out-enhanced 5.25-inch disk copies of Apple-
Works.
TimeOut Pseudodisk contains short directory seg¬
ments from each TimeOut module. You modify the
disk so it reflects the TimeOut modules you own
and leave the modified disk in Drive 2 when you
launch AppleWorks. That eliminates the need to
swap TimeOut disks during the bootup process.
Complete directions appear in a word processor
file on the disk.
We recommend this disk for all users of 5.25-inch
disk systems who own more TimeOut modules
than can fit on one side of a 5.25-inch disk.
Our thanks to Klokhuis, the Apple Users Group of
The Netherlands, and particularly to Dennis de
Leeuw, coordinator of Klokhuis’ AppleWorks SIG,
for developing and contributing this disk to the
NAUG library.
How to Get Disks
Unless otherwise noted, all disks are available in
both 5.25-inch ($4) and 3.5-inch ($6) format, plus
$2 s/h per order. Order from Public Domain
Library, NAUG, Box 87453, Canton, Michigan
48187; (313) 454-1115. NAUG accepts Visa and
MasterCard. All NAUG disks are also available
for downloading from NAUG’s electronic bulletin
board, the Electronic Forum, and from the NAUG
areas on CompuServe, America Online, and
GEnie.
LockOut 2.0
■ Tired of resetting Control Panels after
students leave class?? READ THIS!
LockOut has been upgraded to include
automatic installation on fileservers, hard disks,
GS/OS floppies, and ProDos-8 floppies. It
also features a printed, informative, and fun to
read 40 paged manual. Hundreds of teachers
in the US and Canada are using Lockout to
save themselves hours of drudgery every
week, by preventing students from changing
the Control Panel settings on their IIGS
computers. Priced at $49.95 for manual and
two 800k floppies, including site-license for
all computers in a single building, postage
included. Current owners may upgrade for
$24.95. Money back guarantee.
SuperStuff
3382 Sandra Drive
Kalamazoo, Michigan 49004
Statement of Ownership,
Management and
Circulation
(Required by 39 U.S.C. 3685)
1A. Title of Publication
AppleWorks Forum
IB. PUBLICATION NO
2. Date of Filing
Oct. 1, 1991
o|o|o|o|o | 6 |2
0
Monthly
3A No. of ^Issues Published
12
3B Annual Subscription Price
31.00
49068 Harvest Or., Plymouth, MI 48170
National AppleWorks Users Group, Box 87453, Canton, MI 48187
National AppleWorks Users Group, Box 87453, Canton, Michigan 48187
Cathleen Merritt
49068 Harvest Drive, Plymouth, Michigan 48170
2708 Inwpl l R ri
Complete Mailing Address
, Ann Arbor, MI 48103
AppleWorks Forum
November 1991
Page 33
Members Helping Members
Help with Beagle Bros Enhancements
How to Use this List
To the left of each volunteer’s name are numbers indicating
the utilities the consultant supports. Volunteers are listed
alphabetically by state.
1 = DeskTools
9 = ReportWriter
2 = DeskTools II
10 = SideSpread
3 = FileMaster
11 = SpreadTools
4 = Graph
12 = SuperFonts
5 = gs Font Editor
13 = TeleComm
6 = Point to Point
14 = Thesaurus
7 = PowerPack
8 = QuickSpell
15 = UltraMacros
City Home Work
Arizona -
1-4,7-15 Clay Evitts Tucson 602-885-9789 602-296-5491
4,8,10,12 Bill Holmes Chandler 602-899-4841 602-786-7170
California
1,12,14
Ken Armstrong
Porterville
209-781-3296
805-323-0866
1,6,8,15
Dan Balsley
San Ramon
415-829-5085
8,12,14,15
Brian Blue
Danville
415-838-0997
415-954-6002
1-4,7-15
James Davis
Hayward
415-489-7024
3,12,15
Don Farrar
Pleasant Hill
415-932-5509
1-4,6-15
David Gair
Los Angeles
213-469-9916
213-469-9916
8
Jim Gentilucd
Los Osos
805-528-5049
1-15
Terry Higgins
Newark
415-745-7884
415-593-2500
1-3,10
Lucien LaCour
Woodland Hills
818-348-7787
1-4,8,10-12,14,15
Berenice Maltby
Corona del Mar
714-640-7369
1-3,5,7,8,10-12,14,15 Will Nelken
San Rafael
415-459-0845
415-456-1795
1-3
Jesus Orosco
Milpitas
408-270-1011
408-945-4344
Colorado
8,11,15
Lyle Graff
Littleton
303-794-5970
303-977-4557
4,8,10,14
Geoff Hollingsworth Morrison
303-697-9277
8
John Lefebvre
Thornton
303-451-5558
303-457-2852
8,12,14,15
John Loren
Littleton
303-978-0603
1-5,7-10,12,14,15
Stephen Reiss
Aspen
303-923-6172
303-923-6172
15
Dr. Larry Thaete
Boulder
708-662-2328
708473-2200
Connecticut
3.7.8.10- 12,14 Vincent Castelli Trumbull
4,10,12 JudsonL.Day Groton
3.4.7.8.10- 12,14,15 William Delaney Enfield
12 Martin Knight Middletown
1-4,6,7,10,15 Newton Shaffer Gales Ferry
Delaware -
203-261-2475 203-452-5384
203-445-6600 203445-6600
203-745-4048 203-749-8391
203-346-9698 203-347-8594
203-464-9716
15 W. Henry Linton, Jr. Wilmington
Florida -
1-5,7-15 H.Clay Bailey III
1-4,7-8,10-12,14-15 Bruce Pfeffer
1-15 Jeff Strichard
1-4,7,8,10-12,14,15 Mike Ungerman
Jacksonville
Tallahassee
Ft. Lauderdale
Oviedo
Illinois
302-478-3740
904-744-2499 904-725-3477
904-386-2685
305-587-9590
407-366-0060 407-366-0156
12,15 MarkBaniak
1-5,7-8,10,12,14-15 George Duffey
1-4,7,10-12,15 Douglas Gum
1-3,8,12,14 Susan Husar
Park Ridge
Bloomingdale
Mohomet
Chicago
312-825-6301 312-292-4116
708-894-0849 708-451-3106
217-586-2904
312-631-5884
City
Home
Work
Indiana -
1-3,7-8,10,12
1-4,7-10,12,14,15
Jack Countryman
Kevin Gold
Laura J. Kelley
Greensburg
Indianapolis
Gwynneville
812-663-4998
317-290-8948
317-763-7290
317-543-7098
Iowa -
3,4,8,10,12,15
Kentucky
3,4,11,12
1,3,12-15
Louisana
Maryland
2-4,10,12,14,15
1-3,7-10,12-15
1-4,7-12,14,15
1-12,14,15
1-15
14,7,9,10,12-15
1-3,8,14
6.8.14
15
Michigan
4.6.8.10.14
1,3,4,7-11,15
1.8.10.12.14.15
8.14
Minnesota
1-5,7,8,10-15
1.8.12.15
3.4.15
8,10,12,14-15
12-14
Missouri
1-5,7-12,15
Montana
Nebraska
1-15
1-12,14,15
Keith King
Ft Madison
319-372-9521
Donald L. Corson
Dan Crutcher
Louisville
Louisville
812-256-3517
502-895-1476
502473-3083
502-895-2720
Charles Fryling, Jr
Baton Rouge
504-766-3120
504-388-1473
Raymond Greenberg Darnestown
Ben Maser Owings Mills
Anthony R. Mattern North East
Leon Raesly College Park
Ray L. Settle Arnold
Woodrow Webster FaJIston
301-3304912
301-252-7884
301-6584799
301-647-9192
301-879-7034
301-3534959
301-887-0717
301-658-5535
301-220-3113
301-887-0106
301-887-0171
Donald McCabe
Chuck Scheffreen
Ed Stutsman
Westport
Marblehead
Shutesbury
401-294-6256
617-631-2787
413-259-1217
508-636-2611
617-728-7553
Jim Anker
Michael McMinn
Pete Ross
Deborah Williams
Auburn Hills
Swartz Creek
Wayne
Grosse lie
313-391-0033
313-6554442
313-728-8269
313-671-0267
313-544-5344
313-232-6541
313-675-1550
James Hirsch
David E. Johnson
Dick Kenfield
Sandra Redding
Peter Zambino
Coon Rapids
Minneapolis
Hopkins
Marshall
St. Paul
612421-8393
612-824-2728
612-9384382
507-532-2959
612-690-0536
612422-5572
612-824-2728
612489-1459
Bob Suits
Columbia
314445-6082
Steve Bernbaum
Sheperd
406-373-6393
Jim Corbin
Dr. John W. Kelley
j Larry B. McEwen
Bellevue
Omaha
Hastings
402-291-7285
402-397-3485
402463-2267
402-331-7312
402461-7550
Keith Johnson
Sparks
702-626-2543
702-7844812
603-352-0640
603-434-5407
603-536-3626
Nevada
1-8,10-15
New Hampshire -
1-3,7-12,14,15 Phil Kirkpatrick Keene
7.15 Frank R Savory Derry
8,12,14 Bob Skinner Plymouth
New Jersey -
3,10,12 Mitch Bernstein Medford 609-654-1356
1-4,6-15 PeteCrosta Nutley 201-667-6369 201-677-4050
1.8.10.12.14.15 Link Keur Augusta 201-875-2568 201-992-7000
1-3,6-8,10,13,14 David Scott Wall 201-531-0600 201-681-0600
New Mexico -
1-4,7-12,14,15 Willis George, Jr. Albuquerque
1-3,6-8,10,11,14,15 Gary Young Corrales
505-897-4886
505-897-1770
505-883-9743
505-897-1770
Page 34
November 1991
AppleWorks Forum
Beagle Bros
New York
City
Home
Work
1,2,4,7,8,10-12,14,15 Bob Beer
Coram
516-928-6870
1-2,4,8,10,12-14
Linda Doscher
West Nyack
914-358-7064
3,4,7,8,10,14
David W. Gagnon
Gowanda
716-5324870
10,12,14
Ira M. Garvin
Oakdale
516-563-1253
516489-7620
3,4,7-12,15
Carlos M. Madan
Morrisonville
518-562-0779
518-359-3322
1-15
Larry Merow
Sayville
516-567-0603
516422-0315
1-5,7-12,14,15
James L. Nicoll
Pittsford
716-381-9480
716-546-6732
8
Frances Snedeker
Larchmont
914-834-3081
3,4,8,10,12,14
Jerry Taylor
Rochester
716-964-3319
1,3,4,6,8,10,12,15
Terry Williamson
Orchard Park
716-662-5104
716-873-9750
North Carolina -
3-5,7-10,12 Marc Apfelstadt Greensboro
1-4,7,8,10-12,14,15 Terry W. Robertson Charlotte
Ohio -
919-282-1494
704-5364261
919-334-5970
704-377-0111
14,7,8,10-12,14,15 Jason Chao Cleveland Hts.
3,7,8,12,14 Don E. Fisher Dayton
4,8,14,15 Jason Fogt Lakeview
1-3,7,8,10,11,15 CarmanGreco St Clairsville
1 -5,7-15 Ltc. Robert Weis Beavercreek
Oregon -
14,7-15
1-5,7-12,14,15
1,4,8
14
216-321-5451
513-890-0428
513-843-5779
614-695-5026
5134294169
216-844-3791
513461-2444
513-257-6836
JimEmig Portland 503-771-1916
Norma Gradwohl Brownsville 503466-5668
Dave Lomax Lake Oswego 503-636-7289
Richard Millus Medford 503-772-9787
503-280-5666
503466-5668
Pennsylvania ■
1-3,7-12,14,15
Claude Davis, Jr.
Stewartstown
717-993-6874
717-845-3571
1-3,5-15
Martin Friedman
Broomall
215-353-2753
15
William D. Hall
Philadelphia
215-824-1160
215441-0800
1-3,7,8,14
Joel Perlish
Havertown
215-789-7673
15
Charles R. Schultes Lehighton
215-377-5169
215-377-6180
1-15
Bruce Shanker
Warminster
215-674-0118
3,7,8,12,14,15
Hal Shapiro
Eagleville
215-630-8936
215-922-0500
Rhode Island -
12
Robert J Ricard Cranston
Tennessee -
8,12,14
1-3,7
6
401-781-5202
Jerry Bruce
Bob Evridge
Joel Goldman
Bristol
Knoxville
Nashville
615-652-7473
615-693-8817
615-352-3617
703-676-2999
615-693-9242
Texas
6
1-3,7,8,14,15
1-5,7,8,10-12,14,
1.4.8.10.11.15
1-3,8,10,12,14
Vermont
3.7.8.14.15
4.8.10.12.15
Virginia -
7-8,10,12,14-15
3.10.12.15
Wisconsin
7.8.15
1-3,7,11-13,15
15
Australia
14,7-15
5,10,12
Canada
4,8,15
1-5,7,8,10,12-15
7
1-3,5,7,8,12-14
1-3,7-8,10-12,14,
1-3,7,8,12,14,15
Larry Jones
El Paso
915-533-3302
915-565-3016
Joseph Kline
Lubbock
806-796-0829
15 Ramon Merlin
San Antonio
512496-5331
Bud Simrin
Fort Worth
817-246-0859
Rev. Jerry Venable Liberty
409-336-3178
409-336-6958
Douglas C. Corey
Middlebury
802-388-6209
802-3884021
Linda Metzke
Concord
802-748-3298
802-626-9371
Peter Pfeiffer
Herndon
703437-1985
703-834-3618
Wayne Sheffield
Virginia Beach
804-340-6799
Debby Henning
Sharon
414-736-9229
Peter Lee
Milwaukee
414-229-6660
Todd Novakofski
Ladysmith
715-532-7430
715-532-6202
D.E. Bruce
Caringbah
61 2 5274731
61 2 524 3859
Ralph Morgan
Tweed Heads
075-246811
Michael Beebe
Victoria
6044774630
604-721-7954
John Carson
Montreal
514-965-0886
Patrick M. Duffy
Lethbridge
403-3294211
Brian Elston
Bowmanville
416436-2510
416484-2600
15 Jean Guy Mariage
Montreal
514-9224566
514-252-2541
Terry Price
Schomberg
416-939-8104
City Home Work
5,8,10,12 Robert Sutherland Toronto 416465-2945
1.2.7.8.12.15 Nick Van Helsdingen Tranquillity Base 604-296-3260
England -
12.14.15 Terry Cymbalisty Leeds 0532 525038
4.7.15 Andrew C. LetchfordPlymouth 0752766435 44752766435
6 John Richey Surrey 252 723993 71 409 0092
Israel -
12.14.15 Bernard Katz RamatAviv 03 425-011 03 752-1133
New Zealand -
7.8.12.15 H.P.H. Harrison Auckland 064 9869419
Saudi Arabia -
3.6.8.15 Ken Burnell Dhahran, 31311 3-878-9173 3-875-0051
6 James E. Hanushek Dhahran, 31311 3-8784075 3-877-1533
Switzerland -
1-5,8-10,12,14,15 Charles Kubler Volketswig 01-945-5873
Venezuela -
14,7-12,14-15 OmarQuintero Caracas 02-241-1366 02-291-2526
Electronic Index Disk Update for November 1991
Enter the default values for these categories: Volume #: 7 • Issue #: 11* Date: Nov 91
Letters to NAUG • 2 • Save Your UltraMacros Settings • Neel, Robert • UHraMacros; Apple-
Works 3.0; Mouse; TimeOut
Letters to NAUG • 2 • Problems with RamFAST Cards • Ross, Pete • RamFAST; Charlie’s
AppleSeeds; Quality; OmniShore; hard disks
Letters to NAUG • 3 • Transferring Numeric Data between Modules • Gibson, James • Apple-
Works 3.0; data bases; word processor
Letters to NAUG • 3 • Member Wants Electronic Index • Cangi, Michael • Electronic Index
Novice Notes • 4 • Our Ten Favorite AppleWorks Tips • Williams, Warren; Merritt, Calhleen •
AppleWorks; templates; word processor; data bases; spreadsheet; printers; report for¬
mats; labels;formulas; Mail Merge
Software Review • 10 • Magic File Cabinet Expands AppleWorks Data Base • Raesly, Leon •
Magic File Cabinet; data bases; UltraMacros; word processor; Magical Software
Software Review • 11 • A different technique for using MFC • Raesly, Leon • Magic File Cabinet
• data bases
My Favorite Macro • 12 • Macros that Modify AppleWorks • Clemesha, Barclay • UltraMacros;
macros; AppleWorks; word processor; printing; printing effects
Corrections • 15 • Corrections to the AppleWorks Forum • N/A • corrections
Software Review • 16 • SuperPalch Offers Exceptional DeskJet 500 Output • Knight, Marty •
SuperPatch; DeskJet; printing; printers
AppleWorks Add-Ons • 18 • Current Version Numbers for Vitesse and Seven Hills Software •
Shanker, Bruce • Vitesse; Seven Hills; versions; updates; upgrades
My Favorite Template • 19 • A Medical Insurance and Tax Tracking Template • Hecker, Stan •
spreadsheet; templates; finance; taxes
AppleWorks News • 25 • News and Special Offers • N/A • NAUG; ActaSoft; America Online;
Apple Computer; Claris Corporation; Computer Literacy Press; Diskovery Educational
Systems; GSTape; JEM Software; Marin MacroWorks; Stone Edge Technologies; Time-
Out-Central; 1040Works; taxes; AlphaCheck; GS/OS; Hands-On AppleWorks; Double-
Data; UltraAWesome Macros; DB Master
Data Base Tips • 29 • Three Commands that Can Improve Your Labels • Bennet, Ann • labels;
data bases; report formats
Public Domain Updates • 32 • New Disks in NAUG’s Public Domain Library • N/A • Change-A-
File; Resurrection; Claris Tech Notes; Just Add Water; Mind Teasers; Petty Payroll Tem¬
plates; TimeOut Pseudodisk; Public Domain
Members Helping Members • 34 • Help with Beagle Bros Enhancements • Luoma, Nanette •
Beagle Bros; DeskTools; FileMaster; Graph; GS Font Editor; Point to Point; Power Pack;
QuickSpell; ReportWriter; SideSpread; SpreadTools; SuperFonts; TeleComm; The¬
saurus; UltraMacros
New Key Words: TimeOut-Central; Stone Edge Technologies; GSTape; Diskovery Educational
Systems; Claris Tech Notes; Just Add Water; Mind Teasers; Petty Payroll Templates;
TimeOut Pseudodisk
AppleWorks Forum
November 1991
Page 35
NAUG Membership
Name_
Member N Q , if renewing
Address_
City _ State
Zip _ Country _
Home Phone_
Work Phone_
The AppleWorks Forum — 12 monthly issues, shipped
One
as follows:
Two 1
Circle One:
Year
Years
2nd Class postage - United States
$31
$62
2nd Class postage - Canada and Mexico
$41
$82
1st Class postage - United States
$47
$94
1st Class airmail - Canada and Mexico
$52
$104
Surface mail outside North America
$44
$88
Airmail outside North America
$67
$134
NAUG on Disk 2
$90
$180
Total Enclosed $_
□ Check □ MC/Visa DPO# 3 _
Credit Card Account # _
Expiration Date_
Signature_
1 Avoids future price increases.
2 US. Price. Foreign orders by credit card only.
3 Payment must accompany all purchase orders.
NAUG shares members’ addresses with other users groups and selected vendors. If
you do not want to receive mail from these agencies, check here: □
Apple Works is a trademark of Apple Computer,
under license to Claris Corporation.
Classified Ads
THE HISTORY OF OVER 150 AUTOMOBILE MANUFACTURERS, plus specs to cover
700 automobiles, on disk for AppleWorks 3.0 users. $45.95 for nine volume History Guide,
$25.95 for five volume Spec Guide. Call or write for free demo disk (state disk size). (408)
448-0795; Auto Epoch, 1601 Sundown Ln. f San Jose, CA 95127-4558.
LASER PRINTING WITH ENHANCED RESOLUTION. Send us your Apple II data via
disk, modem, or fax. Overnight and authorial services available! We have a large selection
of PostScript graphics that produce professional results. $1 per page for basic service
plus $2.50 a'h. Discounts for large quantities. Advanced Printing Concepts, Box 97,
Wheeling IL 60090-9998; (708) 215-8466.
JUST RELEASED! DBUG announces the third disk in their popular Quote Disk series.
1001 new quotations to amaze and amuse your friends. AWDB. Same low price. Order
any Quote Disk for $6, any two for $11, or all three for only $15. Money back guarantee.
Data Base User Group, 11 Bellflower, Fairport, NY 14450.
EUROWORKS ADDS FOREIGN LANGUAGES TO APPLEWORKS: Type French, Ger¬
man, Italian, Portuguese, or Spanish quickly and simply with the classic AppleWorks word
processor. Then, from inside AppleWorks, EuroWorks prints your foreign text on an
ImageWriter or true compatible. Text may include every American keyboard character plus
8 special symbols, 13 French, 7 German, 10 Italian, 13 Portuguese, or 10 Spanish char¬
acters. Just one keystroke per accent. No conflict with TimeOut series. EuroWorks
REQUIRES one of these printers: ImageWriter I, II, or LQ; Apple DMP; MT85/86; or
Seikosha SP-1000AP. SPECIFY APPLEWORKS VERSION 2.x or 3.0. EUROWORKS
FRENCH-ONLY ($24), SPANISH-ONLY ($24), or ALL FIVE LANGUAGES ($39). Add $3
S/H. Check, MO, Net-30 School PO, VISA/MC. The S A AuTeur Co A70, Box 7459,
Beaverton, Oregon 97007. (503) 645-2306. Brochure on request.
INEXPENSIVE CHURCH MANAGEMENT SOFTWARE programs for Apple II compatible
computers using AppleWorks. These application templates include record keeping for
membership, finances, contributions, visitation, Sunday school, planning, goal setting,
evaluation, worship, and much more. Special data base of music information from hym¬
nals from many denominations. Many other programs. Send for details: Software Sharing
Ministries, 2020 North Fremont St., Tacoma, WA 98406; (206) 756-7980.
ENHANCE YOUR MACROS. AmperMacros adds new functions and blazing speed to
UltraMacros 3.1. Not just a set of macros or task files, but new commands you can use in
all the macros you write. Disk #1 adds commands for nested loops, floating point math,
direct access to data base info and MORE. Disk #2 adds commands for date/time math,
user inputs, printer control, plus a TO.Date/Time Calculator. Send: $25.00 (includes s/h) for
each disk to: O.P. Software, Box 1042, Mahomet IL 61853. (Indicate 3.5" or 5.25" disk.)
THE PERFECT MACRO FILE! Add files to a full desktop, one key safe Quit, dupe search
data bases, ultra smart-save one or all files, calc pages and jump break to break, full ASP
macros, much more! Extensive screen messages, 2 help screens, full documentation.
4009+ carefully polished bytes with the look, feel, and mnemonics of AWorks. $10 + $2
s/h. Check, MO only. Dan Seibold, 851 Middle Run, Duncanville, TX 75137.
ADVANCED ENGINEERING Z-RAM ULTRA 1 . 256K for lie, corrplete with user's guide
and 3 support disks. T.E. Davis, 1501 Summit, Sioux City, IA 51103. (712)258-8451.
MAGIC FILE CABINET: Extraordinary data base extender that allows reams of written
notes, comments and letters to be instantly available at a key press. Overcomes AW/DB
limitations and transforms your current DBs into a “main frame like" environment. Works in
conjunction with UltraMacros 3.1 and AppleWorks 3.0. Excellent for teachers, businesses
and personal use; for records, notebooks or journals. Retail price $15 plus $2 s/h. NAUG
SPECIAL until 12/31/91 - $10 plus $2 s/h. Maryland only - add 5% tax. Satisfaction guar¬
anteed. Specify 3.5/5.25. Gary Hayman, 8255 Canning Terrace, Greenbelt, Maryland
20770; (301) 345-3230.
SECOND
CLASS
Postage Paid
at Plymouth, Ml
and other offices
NAUG
National AppleWorks Users Group
Box 87453, Canton, Michigan 48187
(313) 454-1115 Fax: (313) 454-1965
BBS: (615) 359-8238
TIME VALUE MATERIAL
Page 36
November 1991
AppleWorks Forum